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
Solved

Ssrs footer problems with multiple page batch reporting

Posted on 2014-04-11
4
1,413 Views
Last Modified: 2014-05-12
I have a report with a header a footer and a sub report in the body.  The sub report has keeptogether false because it can span more than one page.  In print preview I will see the header and footer are missing most of the information (usually obtained from reportitems.)

The reportitems points at a table in the body of the report that gets data from the dataset.  The problem appears to be that the row which has the subreport and spans two pages only seems to bring the reportitems with it that are part of the same row, that means rows above (and frankly below) which can fit on one page are written on the first page and the second page is unable to access those report items which are now considered blank by the report.  How can I give the header and footer access to report items that may be on a different page from the one they are currently rendering?
0
Comment
Question by:UnderSeven
  • 2
4 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 39999699
You have to keep the sub-report together. To test your sub-report you need to run it as a standlone report. Once the subreport is running correctly, then you can import it into your Main Report with the correct parameters that you need between them.
0
 

Author Comment

by:UnderSeven
ID: 40000176
The problem is items on the header and footer, not in the sub report.  It runs fine.
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 40003266
Can you upload your report (or an adapted report that has the same behavior) here?

One thing you could try is add a field with =Globals!TotalPages as expression. This forces SSRS to render the entire report first. This sometimes helps in situations like this.
If it works you can set the text color to white so the value is not displayed.

You say the data comes from a dataset. Can you get to the data directly with the First, Last, Sum and Lookup functions. You can specify a dataset in those functions.

Another option might be to use custom code to store and retrieve the value. See this article for a starting point:
http://technet.microsoft.com/en-us/library/ms155798(v=sql.100).aspx
Then you can try to adapt the information in this article for your scenario:
http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx
It explains how you can send values to custom code and then retrieve those values with another function. You might need to combine this technique with the TotalPages global.

But it is difficult to answer your question with only a global description of the report.
0
 

Author Closing Comment

by:UnderSeven
ID: 40059311
I used a work around where as I cleared the lines, but some of these are very valuable to know.  Rather than uploading the report and messing with this any longer, I'm going to stick with the information you gave which was very helpful.  Thank you.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

837 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