I need pivoting functionality in report studio report in Cognos viewer. Similar functionality is there in Query and Analysis studios but not in Report studio reports.
I hate to tell you this but I don't think thats possible.
Report Studio was meant to be a tool to create static reports that are professional in appearance. Drilling through to another report is usually the biggest user interactivity that you can build.
But please...if you do figure out a way to do this...share it. It would be really cool to have.
Thanks
The closest you could get to pivoting functionality is to have some dynamic data items controlled through prompts.
Eg. Have a prompt called ?Rows? with some static choices like 'Product', 'Employee', 'Year' etc, then have a data item called [Rows]. In the data item, derive the value as
CASE ?Rows?
WHEN 'Product' THEN [Sales].[Product].[Product Name]
WHEN 'Year' THEN [Sales].[Time].[Year Name]
Then do the same thing for your columns.
If you want advanced nesting though it might get ugly.