If you have ever wanted to create a calendar style report and didn't know where to start then this blog post will hopefully help you out. There is a collection of different calendar style reports attached to this post.
a) a calendar created off of a date lookup table (a date lookup table is the recommended method for performance...you can also use an xls or csv if you can't get a lookup table created in your database of choice)
b) a calendar which automatically populates the dates
c) a yearly view calendar which uses small RTF calendars to display the individual months
d) a sample finished report (nicer looking than the above 2) using the date lookup method...this report also contains a couple of small RTF calendars which can be used for linking from month to month
e) a calendar which populates all dates in a range but also has an on-demand subreport for the months (note that this won't have great performance as a subreport is run for each day)
f) a yearly calendar created off of a date lookup table
g) a yearly calendar created off of a date lookup table with charts
There are instructions on the calendars a, b, f & g to help you get this style of report off of your data system...the calendars created off of a date lookup table are by far the easiest to implement and are also the fastest performing calendars.
The yearly calendars f & g are new for 2014 and both use a main report and subreport combo, both formatted with multiple columns, to create the overall view. Although there are no objects in the individual days in these particular samples, you can add objects such as (very small) charts, summaries, etc. to those days as each day is still a report group section.
Calendar Yearly View Populated With a Date Lookup Table
Calendar Yearly View Populated With a Date Lookup Table With Charts Etc.
| Attachment | Size |
|---|---|
| Calendar Which is Populated With a Date Lookup Table | 95 KB |
| Calendar Which Populates All Dates in a Range | 237.5 KB |
| CalendarYearlyView | 1.22 MB |
| CalendarMonthlyView | 468 KB |
Calendar Which Populates All Dates in a Range With On Demand Subreport
- SAP Managed Tags:
25 Comments
