January 26, 2012 at 9:33 pm
Hello All,
I have a grouped report with a page header. The report is grouped to display one company per page. The tablix in the report body is grouped and each company is properly grouping in each page. I would like to put the company name in the header of each page.
The technique I tried using is to create an internal parameter. The default values of the parameter is set to get values from a query. I then specify the dataset and the company name. In report header I have placed a text box that refers to the parameter.
When a run the report the text box in the header displays the same company on each page. I want the text box in the header on each page to display the appropriate company for each page.
Can I make this page header text box dynamic to show the company that corresponds to the page? Is using the parameter/text box the wrong approach? Thanks if you can help?
January 27, 2012 at 8:48 am
Use this expression in your header textbox: =First(ReportItems!CompanyName.Value)
Where CompanyName is the textbox in your tablix displaying company name
January 27, 2012 at 12:47 pm
I have tried that and the problem is the same 'first' name appears on every page. This would work in a single page report showing one company, but not a multiple page grouped report.
I ran the wizard and have the a shell that looks like what I need. the trick looks to be a matrix within a matrix.
I'll report back when I have something more definitve...
February 1, 2012 at 6:16 pm
I resolved this by placing one tablix within another. Using the wizard lead me to this outcome. The outside tablix was grouped on the company name. The inside tablix shows the details for the specific company.
Quite different than other reporting systems where you would see a 'group header'. Thanks.
February 1, 2012 at 6:35 pm
You can add a group header. Right click on the group and add total row, insert above for header. It's a little misleading. Add your company name to the group header, rather than the page/report header.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply