The report has a FROM and a TO prompt. (two separate prompts for the date range)
These parameters are based off of the following conditions (this is just FYI) -
[FIRSTDAYOFF] >= ?FROM? and [FIRSTDAYOFF] <= ?TO?
OR
[BACKTOWORK] >= ?FROM? and [BACKTOWORK] <?TO?
OR
[FIRSTDAYOFF] <=?FROM? and [BACKTOWORK] > ?TO?
CURRENT STATE - When the report runs, its 1 crosstab with summarized data for the entire date range.
Next - In order to get the individual dates from the date range prompt, I'm using a stand-alone Calendar table out of Framework manager and enabling CROSS JOINS. When I run the report, all the dates from the date range are accurately shown!
But the rest of the crosstab still summarizes the data and just repeats for each day in the date range.
NOTE - When I run data for individual days i.e. FROM today and TO today, that's what I want to see for each individual day instead of summarized data for the entire date range.
FUTURE STATE - The idea is to display data for EACH DATE within the DATE RANGE. Instead, the data is summarized. i.e. If the date range is FROM 09-11 TO 09-14, then I should see 4 dates separated;
11th - data for just the 11th (as if I ran the report for date range FROM 09-11 TO 09-11)
12th - data for just the 12th
13th - data for just the 13th
14th - data for just the 14th
Any thoughts?
Thanks so much.
Cognos summarizes the data depending on the granularity specified in the Crosstab.
The crosstab seems not to have the Date in it so all you have to do is to add the Date column in rows or columns depending on how you want to see the data.