Static text to be shown on last page of the report

• VSSGeorge

  SSCrazy Eights

  Points: 8146

  More actions

  May 5, 2017 at 2:52 am

  #323285

  I have a requirement where a static text named ‘Terms and conditions’ which consists of 5 paragraphs has to be shown on last page of the report, ie. body of the report.
  The SSRS report is a invoice report and based on the length of the report, the last page can be second or third page.
  Sometimes it can be second or other times it will be third.
  I tried putting the static text on a tablix. A rectangle is used to enclose this tablix, so that I can write the visibility condition on the rectangle properties.
  There is this tablix, textbox and a logo image inside this rectangle.
  How I can write the expression for showing on the last page of the report.
  Globals!pagenumber is accessible only in page footer. Is there any other way?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  May 11, 2017 at 2:20 pm

  #1942230

  VSSGeorge - Friday, May 5, 2017 2:52 AM

  I have a requirement where a static text named ‘Terms and conditions’ which consists of 5 paragraphs has to be shown on last page of the report, ie. body of the report.
  The SSRS report is a invoice report and based on the length of the report, the last page can be second or third page.
  Sometimes it can be second or other times it will be third.
  I tried putting the static text on a tablix. A rectangle is used to enclose this tablix, so that I can write the visibility condition on the rectangle properties.
  There is this tablix, textbox and a logo image inside this rectangle.
  How I can write the expression for showing on the last page of the report.
  Globals!pagenumber is accessible only in page footer. Is there any other way?

  If you don't want to use the footer, one thing I can think of is that you can force it to be on it's own on the last page.
  With the rectangle, instead of the visibility, try setting the Page Break location for the Rectangle to Start.

  Sue