December 28, 2011 at 11:49 am
My client wants to be able to see all parameter selections displayed in the report, but they want it as a separate tab in the Excel export. So essentially, the first tab in the Excel export of the report would show a list of all parameter selections and the second tab would contain the report detail.
Does anyone know a good approach for implementing this? My first thought was to embed the parameter list and the Tablix containing the report detail within a List control, and then somehow implement a page break between the two, but I can't seem to figure out the proper configuration.
Any thoughts or suggestions would be much appreciated.
FYI - a .NET solution is not an option here.
December 28, 2011 at 1:06 pm
I was able to achieve what I wanted by doing the following:
1) Added List control to report body. By default, a Tablix report item is created within the List control which you can assign a Dataset to. I assigned the same dataset as I'm using in the detail section of the report.
2) Created a calculated field within the dataset which I'm going to use later to group the list by (I just used the expression =1 for this calculated field as I want each row in my dataset to have the same value)
3) Within the list control, added a grouping on the calculated field I assigned in step 2
4) Added text box within list control using separate Placeholder items to store each parameter value
5) Within the list control properties (Rectangle1 in my case), Page break options menu, checked the box "Add a page break after" - this is what separates the "Parameter tab" from the "Report Detail" tab in the Excel export
6) The Tablix containing the report detail is placed outside/below the List control
7) Within the Report Properties, set the Interactive size to 0in,0in
Now when I run the report, the parameters display first and I can click over to the next page to view the report detail. When exported, the report parameters appear on Sheet1 and the report detail appears on Sheet2.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply