arunpandiyarajhen
arunpandiyarajhen

Reputation: 651

Is it Possible to Change the Report Page Name Dynamically based on the Prompt Value in Cognos?

Currently I'm working in Cognos v10.1.2 . I do have a requirement that the report page name (The worksheet name of the report's excel output) should dynamically change based on the prompt value selected. How could we achieve this in Cognos. Thanks in advance for your help.

Upvotes: 2

Views: 6380

Answers (2)

VAI Jason
VAI Jason

Reputation: 544

I believe you can accomplish this in a variety of ways

For example, grouping mechanisms and RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE is set to true

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/c_ug_cra_newfeatures_nametabs_excel2007.html

Also you can do this with rendering and page set definitions

Upvotes: 3

Charley
Charley

Reputation: 11

Unfortunately not, you would have to create separate pages for each code and have them render only if those cards are not missing

Upvotes: 1

Related Questions