If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Calender Report Creation. Please help

Started by ankur10, 17 Sep 2017 05:19:47 AM

Previous topic - Next topic

ankur10

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


New_Guy

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

ankur10

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

Lynn

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.

Michael75

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/

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/
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.

ankur10

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


ankur10

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/

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/
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


ankur10

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).

Lynn

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