Solved

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

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

Expert Comment

by:Mr_Shaw
ID: 25694796
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to import SQL 2000 database to SQL 2014 5 181
Query 14 62
Whats wrong in this query - Select * from tableA,tableA 11 58
calculate running total 8 51
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

739 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