suppressing all details and GH/GF if one detail line is null 2

[DJWheezyWeez]

I'm using CR XI.

Is there a way to do this? I have a bunch of lines in my details section but whenever a null value comes for {table.price}, I would like that entire job to be suppressed, both Group Header/Footer and the details sections. So far, I haven't been able to figure out a way so I'm highlighting lines based on null values so when someone looks at it, it is very visable and they can skip the job. I would like it if this is possible or if there is another way to do it. Any suggestions are welcome.

-DJWW

 

[Madawc]

Do a formula field with something like

If isnull({your.field}) then 1 else 0

Do a summary for the group, finding the maximum.

When the maximum is one, suppress the group. Group suppression should do it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[DJWheezyWeez]

Great suggestion. Almost worked 100%. When I use your idea, it suppresses the header and all the lines in the detail section that are null but leaves the lines that aren't null. Maybe I didn't explain my problem right but I would like it to also suppress the lines that aren't if any lines for that job are null. So if in one job, I have 100 lines of details and one of those lines are null, I want all the other 99 lines that aren't null to also be suppressed. Is there a way to do this?

-DJWW

 

[lbass]

Use Madawc's formula --let's call it {@isnull}. Then go to report->selection formula->GROUP and enter:

sum({@isnull},{table.groupfield}) = 0

-LB

 

[DJWheezyWeez]

Works great! Thanks Madawc and lbass!