Custom Date Range Header for mutliple date ranges

[crogers111]

CR XI
SQL

I have a report setup in Business Object Enterprise that I want to run for 2 different date ranges. I have the selection criteria working for each 'Instance' in BOE (In BOE you can have different record selection criteria run for the same report) I cannot figure out how to have a custom date range label to reflect the 2 different date rangess in the same report.

Here's an example of the Record selection critiera for each instance which works correctly:

1. {Data.CheckDate} in LastFullMonth
2. {Data.CheckDate} in {PlanStartDate} to @LastDayofPreviousMonth

The scenario that seems to be giving me the trouble is this one:

Let's say PlanStartDate = 7/1/2010

And I run the report with each selection criteria on 9/1/2010. Let's say there were no records with a {Data.CheckDate} in July so only August data exists.

How do I use the same report and have 1 label show that the report was run for August Data only (LastFullMonth) and within the same report have a date header/label that shows when the report was run for the second date range (7/1/2010 - 8/31/2010)...when no July data exists ?

 

[Madawc]

One solution would be to add a table for the months, then use a left-outer link from the month to the data.

If you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.

Each running total will count the record if it was within the criteria

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP