Solved

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

Posted on 2008-11-03
3
440 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

691 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