Solved

Need expression to tell me when SSRS report is at bottom of page

Posted on 2008-11-03
3
437 Views
Last Modified: 2012-05-05
Can a SSRS expression be created to tell me that report is at the bottom of a page. I want to try and print the bottom border at the bottom of each page just  before  page footer prints and report skips to new page.

What I want to do is try to print the bottom border on each page. Right now, if I print a ten page SSRS report, the bottom border only prints on the last page of the report. I would like it to print at the bottom of each page. The report looks cleaner that way. This is a table type report.




0
Comment
Question by:thayduck
3 Comments
 
LVL 18

Expert Comment

by:DarrenD
ID: 22867901
Hi,

I'm not positive but it sounds like you have put the border on the footer of the table instead of putting the the border in the footer or each report page.

If you open your report in VS and then choose Report / Page Footer from the menu you can draw a line there and that will appear on the bottom of each page.

I might be completely wrong but just what I got from how you have explained it.

Cheers,

Darren
0
 

Accepted Solution

by:
thayduck earned 0 total points
ID: 22869103
I tried doing that but could not make the border line line up with the left and right border lines.
It would look pretty good if viewing online but would look bad if you printed report.

I think key is getting bottom border of detail line to print when I know I am at bottom of page.
0
 

Expert Comment

by:Mr_Shaw
ID: 25694796
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Move SQL 2005 Express to Server 2012R2 19 125
Error when saving to sql table a '/' 5 28
get most recent and second most recent date in SQL Server 24 90
Restrict result set 1 38
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question