April 9, 2014 at 9:40 am
I have a problem for which I'm not sure there is a solution. I have a matrix with a group that has 3 possible values--call them type1, type2 and type3. There are page breaks for each type. So if the user generates the report for all 3 types, each page will be devoted to a single type. When the report is generated, the user may select any or all 3 types. I want to dynamically change a column name in the report. The column name should be different for type3 than for types 1 and 2. I used an IIF statement in the column name, which works if the user selects a single type but not all 3. Once the report is generated, is it possible to change a column name from one page (or type in this case) to another? So essentially as you traverse through the report, the column name would change when you get to type3.
Thanks for your help.
April 9, 2014 at 12:19 pm
jeffhibbert (4/9/2014)
I have a problem for which I'm not sure there is a solution. I have a matrix with a group that has 3 possible values--call them type1, type2 and type3. There are page breaks for each type. So if the user generates the report for all 3 types, each page will be devoted to a single type. When the report is generated, the user may select any or all 3 types. I want to dynamically change a column name in the report. The column name should be different for type3 than for types 1 and 2. I used an IIF statement in the column name, which works if the user selects a single type but not all 3. Once the report is generated, is it possible to change a column name from one page (or type in this case) to another? So essentially as you traverse through the report, the column name would change when you get to type3.Thanks for your help.
I'd try setting up a header with an expression based on the parameter, something like this:
==Parameters!Type.Label(Globals!PageNumber-1)
where "n" starts at 0 for the first page and goes up to the last page number -1
Gerald Britton, Pluralsight courses
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply