COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ankur10 on 17 Sep 2017 05:19:47 AM

Title: Calender Report Creation. Please help
Post by: ankur10 on 17 Sep 2017 05:19:47 AM
Hello Everyone,

Could you please let me know, how to create calender kind of report. Where on clicking in each date day will show event of that day.

Thank you,
Ankur

Sent from my MotoE2 using Tapatalk

Title: Re: Calender Report Creation. Please help
Post by: New_Guy on 19 Sep 2017 10:16:35 AM
Hi,
If you are talking about a prompt that prompts a user to select a date, then you can use a date prompt and use that parameter in a filter for the query which brings in all the events for that selected date. If this is not what you want, let us know the requirement a bit more clearly.
Good luck
New guy
Title: Re: Calender Report Creation. Please help
Post by: ankur10 on 23 Sep 2017 05:43:07 PM
Hello

Thank you for replying. I wanted to create a calendar like an outlook schedule meeting type. In the calendar it shows small details. And once we click on it shows full details.

Thank you for all your help and time.

Thank you,
Ankur
Title: Re: Calender Report Creation. Please help
Post by: Lynn on 25 Sep 2017 07:14:34 AM
You might want to investigate a repeater table layout container. You'd set it to 7 across and 5 down. Within each you'd include your information with drill through as needed to details.
Title: Re: Calender Report Creation. Please help
Post by: Michael75 on 25 Sep 2017 07:52:05 AM
Here are two rather old blog posts which could help get you started:

1. From Ironside Group. this uses a master detail relationship to allow multiple events per day. Maybe this would be overkill for you
    http://www.ironsidegroup.com/2010/05/04/presenting-in-calendar-format/ (http://www.ironsidegroup.com/2010/05/04/presenting-in-calendar-format/)

2. From Nimrod, a much missed former contributor to this forum
    http://cognote.wordpress.com/2012/03/11/viewing-your-monthly-data-as-a-calendar/ (http://cognote.wordpress.com/2012/03/11/viewing-your-monthly-data-as-a-calendar/)
This mentions an IBM link pointed out on this forum by Lynn. The link is no longer valid, but I have a copy of this (old) article, if you want to contact me by private message.
Title: Re: Calender Report Creation. Please help
Post by: ankur10 on 25 Sep 2017 08:58:42 AM
Quote from: Lynn on 25 Sep 2017 07:14:34 AM
You might want to investigate a repeater table layout container. You'd set it to 7 across and 5 down. Within each you'd include your information with drill through as needed to details.
Thank you soo much for your help and time. I will try to implement it.

Sent from my MotoE2 using Tapatalk

Title: Re: Calender Report Creation. Please help
Post by: ankur10 on 25 Sep 2017 09:00:00 AM
Quote from: Michael75 on 25 Sep 2017 07:52:05 AM
Here are two rather old blog posts which could help get you started:

1. From Ironside Group. this uses a master detail relationship to allow multiple events per day. Maybe this would be overkill for you
    http://www.ironsidegroup.com/2010/05/04/presenting-in-calendar-format/ (http://www.ironsidegroup.com/2010/05/04/presenting-in-calendar-format/)

2. From Nimrod, a much missed former contributor to this forum
    http://cognote.wordpress.com/2012/03/11/viewing-your-monthly-data-as-a-calendar/ (http://cognote.wordpress.com/2012/03/11/viewing-your-monthly-data-as-a-calendar/)
This mentions an IBM link pointed out on this forum by Lynn. The link is no longer valid, but I have a copy of this (old) article, if you want to contact me by private message.
Thank you for your help and time. I will go through it and will request for your guidance if im not able to do so.

Sent from my MotoE2 using Tapatalk

Title: Re: Calender Report Creation. Please help
Post by: ankur10 on 25 Sep 2017 10:25:52 PM
Hello Lynn,

I have done this. can you guide further plz

Create a List report on the page.
Insert a table with 6 Rows and 7 Columns.
Set the cell heights and width to your needs (I used 100px x 100px in the example).
Title: Re: Calender Report Creation. Please help
Post by: Lynn on 26 Sep 2017 02:32:10 AM
Quote from: ankur10 on 25 Sep 2017 10:25:52 PM
Hello Lynn,

I have done this. can you guide further plz

Create a List report on the page.
Insert a table with 6 Rows and 7 Columns.
Set the cell heights and width to your needs (I used 100px x 100px in the example).

Look in the toolbox for a layout container that is called a repeater table. This is not the same thing as a list.

The user guide has more information on repeater tables.

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id2993rs_lists_repeaters.html