Crosstab Rows & Columns Based On Formula 1

[govmule]

Hello,

I'm using Crystal Reports 8.5 connected via native drivers to an Informix Dynamic Server 7.3 database.

I'm new to crosstabs so please forgive any lame questions.

I've created a very simple crosstab based on the following formulas:

Row:
If {@Enrollment Status} = 'CI'
and {@Educ_Status} = '-In'
Then 'In School'
Else
If {@Enrollment Status} = 'CI'
and {@Educ_Status} = '-Out'
Then 'Out of School'

Column:
If {@Enrollment Status} = 'CI'
and {@Older_Younger} = 'O' Then 'Older'
Else
If {@Enrollment Status} = 'CI'
and {@Older_Younger} = 'Y' Then 'Younger'

Summary:
DiscinctCount wia_case.wia_app_num

My problem is that the remaining records not meeting these criteria are also showing up in the Crosstab with a blank column or row heading.

Why?

I can attach the syntax for the associated formulas if necessary.

As always, I'm grateful for the assistance.

Thanks,

Jack

 

[lbass]

Hi Jack,

In the crosstab, select the row field_>group options->specified order and enter "in" and "out".Then choose the "Other" tab and check "Discard all others." Repeat for the column field.

I was going to suggest that you could use your enrollment status criteria in the record selection formula to limit the report to "CI", which I'm guessing stands for "carry-in", but because these youth could have multiple enrollments in WIA, you probably can't do that in the record selection formula, since you would probably need to reference a maximum enrollment date...

-LB

 

[govmule]

LB,

Yes! You sir, are the Man!

Thanks,

Jack