How do I make ssrs header go through recordset

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?
UnderSevenAsked:
Who is Participating?
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
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
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
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
 
UnderSevenAuthor Commented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
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
 
UnderSevenAuthor Commented:
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
 
UnderSevenAuthor Commented:
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
 
Koen Van WielinkBusiness Intelligence SpecialistCommented:
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
 
UnderSevenAuthor Commented:
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
 
UnderSevenAuthor Commented:
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
 
UnderSevenAuthor Commented:
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
 
UnderSevenAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.