Suppress Specific Lines

[MikeCopeland]

Using CR XI...
I'm sure this has been asked and answered before, but I couldn't find it in this forum. My apologies...
I have a report with lines having no data. For example:
Caucasian 11
Hispanic
Afro-American 1
Native American
Multi-Racial 1
Other
I'd like to eliminate the lines that have no value (Hispanic, Native American, Other). I'm able to suppress the 0 values, of course, but it'd be better to eliminate the whole line altogether when the count value is zero. Any thoughts? TIA

 

[Turkbear]

Hi,
If these are separate records then using a selection criteria to eliminate records having NULLS ( or blanks, depending on the database) in whatever field has the number will do what you want.




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[mocgp]

If your lines are groups with summaries then just go into the Section Expert and, in the Suppress X2 formula, select your summary from the Report Fields list and set it equal to zero

{Group #1:FIELD_NAME_X - A:Sum of FIELD_NAME_Y}=0

 

[MikeCopeland]

No, I don't think either answer applies. These "records" are separate items placed in a Group Footer line. I suppose I could create formulas that would format the 2 portions of each line (the text string, the value display) and either return the concatenated strings...or a blank. However, this would show "gaps" in the Group Footer what I'd like to avoid.
Also, there's the issue of _how_many_ of these lines could possibly exist: there are as many as 30 "race" counts in this report - but I didn't show all of them in this example. Thus, there are probably a few that have pertinent data, but many that don't. The report looks ugly with all these "empty lines" (info with no counts), and that's where I'm headed with this query...

 

[lbass]

So how are these counts created? Are they inserted summaries? Are they formulas? If you placed them each in their own group footer section GH_a, GH_b, etc., you could conditionally suppress each footer and also format each section to "suppress blank section" and then you wouldn't have any blank space.

-LB