COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Chamopak on 03 Jun 2015 09:26:18 AM

Title: Display Tuple members in Column header
Post by: Chamopak on 03 Jun 2015 09:26:18 AM
Hi

Is their a way to display the the tuple members within the column header?

Scenario:
Have 2 prompt placed into 2 query calculations:
- Select Month
- Select year

These are used to form a tuple
tuple([Select Month],[Select year])

If I choose the month of september and the year of 2014, I would like that the Column head to be September 2014 instead of tuple

Thank you in advanced,
Title: Re: Display Tuple members in Column header
Post by: TheFrenchGuy on 03 Jun 2015 09:54:31 AM
Hello,

you can go to your column title and in properties, you change "Member Caption" in Source Type, by "Report Expression".
Below, you can put a formula in "Report Expression". You can fill : ParamDisplayValue('name of you parameter')