Calender Report Layout

[Raghuvir]

Hi All,

Has anyone worked on preparing a calender report in cognos ? i have attached a sample image of the report layout.

Request you to guide me to achieve the layout of the report.

Regards

[BigChris]

Have you managed to get the base data for your report? You should be able to calculate the Sunday, Monday etc. element using _day_of_week and a case statement. Your screenshot looks like this is an existing report...is that correct?

[Raghuvir]

Hi BigChirs,

this is the first time i have come across such a requirement. i have not yet started working on this, just analysing how to go ahead.

the screenshot that i have attached is the sample image.

Request yout to guide me to tackle this requirement.

Regards

[Michael75]

Raghuvir, here's an article from Ironside that may be of use to you:

http://www.ironsidegroup.com/2010/05/04/presenting-in-calendar-format/

Also, here's an old Cognos article which shows a calendar presentation that looks quite a lot like yours. There's a report spec too. NB This was for C8.2.

http://www-148.ibm.com/bin/newsletter/tool/landingPage.cgi?lpId=2418&open&cm_mmc=6291-_-n-_-vrm_newsletter-_-11022_139746

HTH
Michael

[Raghuvir]

HI All,

is it possible to get a calender layout if you just have the current_date function ?

Request you to give me some tips on this topic.

Regards

[BigChris]

Why would you only have the current_date function? Without the other functions I can't see a way to create the output you're looking for.

[Raghuvir]

Hi BigChris,

I mean to say i have a data item in which i have current_date, now will it be possible to calculate all the days of the month and weeks using various functions ?

have you worked on such requirement before ?

Regards

[Michael75]

So you want to print a calendar, where the dates are somehow based on the current date? And where is the data coming from that you're going to show in the days of this calendar?

Obtaining a range of dates around the current date will be easy, whereas putting your data in the right box might be less so.

Perhaps if you clearly state your full requirements, rather than releasing just a snippet at a time and letting us try to guess the rest, you'll receive a quicker and more satisfactory answer.