Suppress Function

[Hillary]

The following formula is in the Suppress section (in Format Editor) of my subreport field on the main report.

GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "NYS ELA" and
GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "Total Reading" or
{0405_CSL_SMS_District_Subj_Item_3.NAME} <> "Reading Achievement"

I have a report that is bringing students into the report if any of their test scores (English, Math, Science or Social Studies) fall below a pre-defined level. If their test score comes into the report, I am also bringing in their grade from last year.

For English, a student could have 2, 1 or no test scores showing under English. (2 scores means the student failed both 4th & 5th grade tests; 1 scores means the student failed the 4th or 5th grade test; no scores means the student did not fail either the 4th or 5th grade test)

Here's the problem...

Where a student failed the 4th (NYS ELA) and 5th (Total Reading) grade test, Crystal is duplicating the grade.

Example...


English Score Reading Grade Writing Grade
Student A 639 (5th) 3.00 3.44


Student B 26 (4th) 2.13 2.63
626 (5th) 2.13 2.63


Student C 41 (4th) 2.63 2.44

I would like to see Student B printing like...

English Score Reading Grade Writing Grade
Student A 639 (5th) 3.00 3.44


Student B 26 (4th) 2.13 2.63
626 (5th)

Is there a way to write the formula so it first looks for one test and if that's not there, then looks for the other as opposed to having the grades repeat themselves?

Thanks,

Hillary

 

[lbass]

It's hard to tell what might work since I think even your first example is after some suppression has occurred, so we don't really know what the underlying data looks like. You could insert a running total {#cntwingrp} where you select the studentID, use count as the summary, and in the evaluation section, choose "use a formula"->x+2 and enter:

GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "NYS ELA" and
GroupName ({dbo_CSL_SET_SUBTEST_CODE.SUBTEST_CODE_DESC})<> "Total Reading" or
{0405_CSL_SMS_District_Subj_Item_3.NAME} <> "Reading Achievement

Reset on change of group (student ID)--if you don't have a group on this, insert it.

Then right click on the fields you want conditionally suppressed->format field->common->suppress->x+2 and enter:

{#cntwingrp} <> 1

This approach will take into account that you might have records before or inbetween the records actually displayed for each student.

-LB