Toan Nguyen
Toan Nguyen

Reputation: 11601

Showing information at the bottom of the last page in the report

I would like to show long text ( several paragraphs) at the bottom of a report using SSRS 2008 R2.

I have been searching around but it seems that there aren't any available solutions. If I put the a text box in the footer and then reference to a hidden field in the report body, then on the intermediate pages, there would be a big plank gap in the footer, which apparently isn't what I want.

Could you guys provide me with some solution for that. Thanks in advance.

Upvotes: 2

Views: 6701

Answers (2)

K D
K D

Reputation: 5989

You can do the trick by adding footer in your report.

  • Add a footer in the report
  • Add one Text box in that footer with your description
  • Remove footer border and Draw your own line above textbox(If you want to show footer separetly)
  • Add following condition to the TextBox visibility expression

=IIf(Globals!PageNumber = Globals!TotalPages, False, True)

Upvotes: 3

M.C.Rohith
M.C.Rohith

Reputation: 3750

Put the TextBox at the end of the report and not in the footer in the design view.

Then the Text box will appear in the end of the report.

Hope this will solve your problem.

Upvotes: -1

Related Questions