Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

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?
0
UnderSeven
Asked:
UnderSeven
  • 7
  • 4
1 Solution
 
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
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

 
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
 
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
 
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now