I have a number of cross tab reports that need to be created to build a subset of data.
The data in the columns of these cross tab are always going to be the same. However, i need to change the data the table looks at in the rows.
So one crosstab would look as follows -
MTD M-1 YTD YTD-1
Sales by Channel Vol
Sales by Channel NRR
Sales By Channel Cont
Then i need to create a second cross tab which is by -
MTD M-1 YTD YTD-1
Product Family Vol
Prodcut Family NRR
Product Family Cont
and so on, each crosst tab pivoting on the same values but with a different attribute.
Is there a way of creating a report structure in Report Studio that could simply contain the relevant Columns and then as a perhaps a prompt choose the relevant level of the report or set it to repeat. I thought adding a repeater from the insertable objects list would allow me to do so , but when i extract the report it only pulls out the first crosstab so i'm now a little stuck.
Cheers
You can make the attribute dynamic by refering to a parameter value in the definition of the dataitem used in the layout:
CASE
?PARAM_ATTRIBUTE?
WHEN 1 THEN [SALES_BY_CHANNEL]
WHEN 2 THEN [PRODUCT_FAMILY]
....
....
ELSE NULL
END
The ?PARAM_ATTRIBUTE? is then the parameter value associated with a text prompt that is populated with all possible Attribute values.
Here the assumption is made that each attribute is represented by its own dataitem..