Hi, In my prompt page, I have a value prompt in which I'm display "Country Code || - || Country Name" in prompt values so that the users can select the appropriate country(s) they are interested in.
Our requirement is to have a page break on Country Code (our fact table only has country codes in it, no country names and I'm joining the fact table to my Country dimension on country codes to display "Country Code - Country Name" in my prompt values)...The report is running fine and the page break is also working fine....Our users now came up with the requirement of displaying the Country Code || - || Country Name (the value that we selected on the prompt page) to be displayed on the report header and the issue I'm running into is...when I use the ParameterDisplayValue('Country') in my report header...all the countries that we select on the prompt page are displayed on each tab of the excel workbook instead of only displaying the one country for which there is data in that spreadsheet.
Can someone please shed some light?
I'm using Cognos 10.1.
Thanks in advance!
KC