Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I make ssrs header go through recordset

Posted on 2014-03-25
11
Medium Priority
?
406 Views
Last Modified: 2014-03-27
I have a bill template in ssrs.  I want to be able to run it against a table of bills and have it in one file generate the bill for each in the table.  This means that I need the textboxes in the header and footer to be able to change depending on what bill I am on.

I know I can do this with reportitems, but I'm not sure how to populate reportitems with fields from a recordset.

How is this accomplished?
0
Comment
Question by:UnderSeven
[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
  • 7
  • 4
11 Comments
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39955066
If the header and footer you're referring to are the report header and footer you probably won't be able to achieve what you want.
Instead, use group headers and footers and have the report group per individual bill.
0
 

Author Comment

by:UnderSeven
ID: 39956139
I have seen reports with report headers and footers do this (how else would you use page number globals).

But trying your way I'm not sure how to make a specific group header, can you elaborate please?
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39956169
First of all, which version of SSRS are you using? Is it possible for you to attach the rdl? If you insert a group in your report for the bill number or whatever the unique identifyer of a bill is, you can use group header and footer instead of the report header and footer.
I can be more specific if I know your RS version.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:UnderSeven
ID: 39956192
I'm writing the report on visual studio 2012, our report server is 2008.

What I am attempting to do is use a hidden table in the report body for grouping and giving me access to the rows.
0
 

Author Comment

by:UnderSeven
ID: 39956254
I attached a sanatized version of the rdl

As you can see I have a hidden table that links to the dataset and groups on the billidnumber.  Most of my text boxes in the header are looking at parameters, I plan to change that, in the upper right corner is a text box I pointed at reportitems for the bill id.  

It doesn't work, it only lists the most recent bill id on the list
Bill-MainOnePagedeploybat325san.rdl
0
 
LVL 13

Expert Comment

by:Koen Van Wielink
ID: 39956312
Ok, from what I can gather you would have to make the tablix you've hidden fit the entire page. The header expressions should go in the group header instead. Unhide the table and only hide the rows/columns within the table which you don't need. If you want this to work, the tablix containing your grouping has to be the main report template. Right now because you're using the background page rather than the actual report (the table), it would only show you the last item retrieved. The subreports also need to be placed within the main table.
0
 

Author Comment

by:UnderSeven
ID: 39956618
I think I understand.  Is there a way to do this with xml quicker than re-writing? This is based on a template that is a little more complex than the version I just sent so it would take a while.
0
 

Author Comment

by:UnderSeven
ID: 39957571
I tried using a table in the report to use a reportitem to feed a value to the header, still won't work.  So can I not use report headers?
0
 
LVL 13

Accepted Solution

by:
Koen Van Wielink earned 2000 total points
ID: 39957691
Wouldn't try this through xml. Pretty sure that would take longer, if it would work at all. Report headers are really for titles, dates, author, etc, static data which is the same for the entire report, not for dynamic data. Your data changes for each set of records belonging to the same bill id, so your "header" data needs to be in a group header for a grouping on that field.
0
 

Author Comment

by:UnderSeven
ID: 39959500
I'm not quite sure how to do this.  What I've attempted is create the table based on the dataset, group by the bill number, child group with details.  If I populate just say one row with the bill number and leave it in the table it repeats the bill numbers, if I drag that textbox out of the table it lists only once.  How do I use a table with a layout like this, am I supposed to be able to drag the textbox pieces and have them maintain table behavior?
0
 

Author Closing Comment

by:UnderSeven
ID: 39959721
Thanks a lot for going through it with me.  The way I eventually did it was (taking your advice) removing the header and footers since they're not meant for dynamic and then to simplify migration I created a report with a table that fed the bill number to the main template as a subreport.  This enabled me to keep both within the previous design.  Ultimately it worked out rather well I think.  Thanks a lot for the help.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

604 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