Static Crosstab Columns

[kriesten]

cr 8.5
Oracle database
windows XP

I am trying to create a crosstab to display a schedule for each month and within each month I want to show a static frequency of occurrence whether there is data to support the column or not.

I am counting the number of records assigned the frequency.

For Example:
May | June | July
----------------------------------------------------------
Mthly|Qrtrly | Mthly| Qrtrly | Mthly| Qrtrly
----------------------------------------------------------
AHU 0 | 0 | 1 | 0 | 0 | 1
AC 1 | 0 | 0 | 1 | 0 | 0

In this case I would like to show the May Qrtrly column and the July Mthly column whether there is data or not. What Crystal does is only show the column header when there is data to match both cases.

Essentially is there a way to force or make static columns even if there is no data at the time to fill that particular column?

Help would be appreciated.

Thanks in advance.

 

[lbass]

I think you would have to use a manual crosstab to accomplish this. You would group on whatever your row field is, and then create formulas of the form:

//{@May-Monthly} to be placed in the detail section:
if month({table.date}) = 5 then 1

Not sure what you mean by your "Quarterly" column, so I won't venture there, but you would need a specific formula for each column. You would then insert summaries (SUMs, not Counts) on each formula and suppress the details section.

-LB

 

[kriesten]

Thanks for the reply.

I thought that would probably be the direction to go in.