Calendar: Multiple Tables

[Bhadley]

Hi All,

I am looking to see if there is a way to create a Calendar Report that shows two tables. We currently have a calendar that shows Change Requests and when they are scheduled by their planned date. We would also like to add Change Tasks onto this same calendar.

The calendar options are fairly limited, I also took a peek at Database Views as well but this didn't seem help with this sort of functionality. Wanted to post this out there to see if anyone else has accomplished this or had any other creative ideas of doing something like this. Thanks!

[mariochanes]

I needed to create a calendar report for GRC which would show past, present, and future control test instances.

The report needed to get data from the grc_control_test and the grc_control_test_definition tables. I remember trying to use database views but the values on the calendar were all jumbled and it was useless.

My solution was to create a new table which would hold a copy of all the current records in the grc_control_test table, that table provided me with the past and present records.

Next my script made a copy of all of the records in the grc_control_test_definition table, that provided me with the date that the future control test instances would generate.

You could script a business rule which upon insert/update would populate your new table with the data from both of your tables. Then you just need to run a calendar report off your new table.