Dynamic Date Column headings based on prompt

[cogjai]

Hi all,

I need to generate a report, where the column headings should be based on the prompt supplied by user. The user will enter the date in yyyymm format. We have 5 column headings where the first heading should be last date of the month. The next column headings should be the Mondays of all the weeks in that particular month.

Ex: If user enters 200401 i.e. January 2004, the column headings should be like this.

31-Jan-2004 which is last date of the month
26-Jan-2004 which is last monday of the month.
19-Jan-2004 which is third monday of the month.

like this i need all the 5 column headings. Is there any way that we can achieve this in cognos reports.

thanks

 

[griffindm]

cogjai,

Check out thread401-647456.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com