COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: matthew on 22 Dec 2011 05:14:02 AM

Title: Showing the paramdisplayvalue for the paramvalue -1
Post by: matthew on 22 Dec 2011 05:14:02 AM
Hi,

question about paramdisplayvalue() and paramvalue().

I have a report with a date in it. It's a crosstab, which shows customers on the rows, and the selected month on the columns. These months are relative months, this means that if the user selects november 2011 (the paramDISPLAYvalue), the system will see -1 (the paramvalue) because the current month, in this case december, is always 0.

The report output will nicely show the paramdisplayvalue (november 2011), but i also want to show the previous month (in this case october 2011). So, i want to show the paramDISPLAYvalue for the by the user selected paramvalue -1. How can I do this?

Thanks in advance