Solved

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

Posted on 2008-11-03
3
434 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
Comment Utility
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
Comment Utility
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
Comment Utility
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

6 Experts available now in Live!

Get 1:1 Help Now