Solved

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

Posted on 2008-11-03
3
435 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

932 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now