Cross tab to show empty columns 1

[smithcza]

Hi

I am using cross tabs to report data. I want the cross tab to ALWAYS show 9 columns even if I only have data for less columns (Ex. If for a particular report, I only have data in 5 columns, but I still want 9 columns to apear on the report - with the last 4 empty).

Furthermore, if there are data in more than 9 columns, a new table must be started on the next page with the rest of the data - I am doing this allready, but would like to combine it with the part mentioned above. The formula
// GroupNo and AnaNo initialized in InitCounts Function
//GroupNo = 0;
//AnaNo = 0;

WhileReadingRecords;
Global StringVar RepSeq;
Global NumberVar AnaNo;
Global NumberVar GroupNo;
Global StringVar AnaCode;


if AnaCode <> {PJSA.SA_ANALYTENAME} then
(
AnaCode := {PJSA.SA_ANALYTENAME};
AnaNo := AnaNo + 1
);

// 10th sample becomes first sample of next group
if AnaNo > 9 then
(
GroupNo := GroupNo + 1;
AnaNo := 1
);

GroupNo
)


Can this be done?

Regards,

SmithcZA

 

[Madawc]

I think you'll need to create a 'mock crosstap' -a grid of running totals that duplicate the crosstab function, but still show if they are zero.

You should have an example of 'mock crosstap' supplied along with Crystal.

Madawc Williams (East Anglia, UK)