Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to display disclaimer message in end of the report Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 6:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
Hi,
Please let me know how to display disclaimer message in end of the report in SSRS report.
Like...<<<DISCLAIMER: confidence and probability information......>>

Thanks,
Post #1462873
Posted Friday, June 21, 2013 9:34 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, September 12, 2014 7:02 AM
Points: 422, Visits: 1,317
Pop a text box in the page footer with the information you want.

In the text box visibility properties hide based on the following expression

=Globals!PageNumber<>Globals!OverallTotalPages

This will only display on the final page in the footer
Post #1466261
Posted Monday, June 24, 2013 7:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:49 PM
Points: 171, Visits: 501
If you don't necessarily want the disclaimer to print at the bottom of the last page, you can put the disclaimer is a text box in the body of the report after the last tablix of the report design. If I were in your shoes I would experiment with both approaches to see which is the better look to the output.

I had a report requirement to print a "tear off" section at the bottom of the last page, and it had to fit pre-printed perforation, so I used the technique suggested above successfully. But if it doesn't have to be at the bottom, it might make more sense to print it after the last data region instead of forcing it to the bottom of the page.

It is always good to have options so that you can select the best approach for your design specifications.
Post #1466748
Posted Sunday, June 30, 2013 10:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
Thanks for Your suggestion. Let me check with my Client.

Thanks Lot.
Post #1468919
Posted Sunday, June 30, 2013 10:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
.
Post #1468920
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse