COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dblinde on 05 Jun 2013 04:12:00 AM

Title: Calendar display
Post by: dblinde on 05 Jun 2013 04:12:00 AM
I developed a simple calendar with Cognos.

(http://4.bp.blogspot.com/-woyZfMiLFJI/Ua78CEpZukI/AAAAAAAAD3E/b_zzegS9dxE/s1600/kalender.png)

It can be used to display all kinds of data, we use it to display the status of de load of the datawarehouse.

I used a repeater table. The trick is to give each cell a gridnumber. With a simple formula you can calculate the gridnumber for each day of the year. The formula : [WeekDayNumber] +( ([IsoJaarWeekNr]-?yearweeknr?) * 7)

Placing a list item in the repeater cell and connecting it you can display anything in the grid.
I used a simple javascript to enable the previous (vorig in Dutch) and next (volgend in Dutch) hyperlinks.

Hope you enjoy this solution!
Title: Re: Calendar display
Post by: MFGF on 05 Jun 2013 04:37:00 AM
Nice!

Thanks for sharing! :)