Supressing fields with no records 1

[ezamon]

I have category names in Group header #1 which I would like to return only issues that are open.

Example:
Field name Count of open issues
Sales 2
Computer 4
Email 1
Marketing 0
Car 10
So I'd like to take out the "Marketing" that has Zero issues. I know how to supress Zeros, but I do not know how to supress the field names that have zeros next to them.
thanks for the assistance

 

[Cretin]

Is what I did is I went into format section of the detail line. You will get a box with a list of things you can do. One of them is suppress. To the right of that is a little box with a X-2 and a pencil under it. Double click on that. You can now create a formula to supress a line if a field = 0. example {count}=0 you put that in the formula box under supress and that tells crystal to supress that section everytime the above formula is true.

Cretin

 

[ezamon]

Cretin thanks for your post before, it worked but now I have spaces where the supressed rows are, do you know how to fix that?
EZ

 

[synapsevampire]

A simpler and faster means is to use the Report->Edit Selection Formula->Group:

count({table.issues},{table.Category}) > 0

This will eliminate those rows from the records returned from the database. The method supplied by Cretin will still have the rows in the report, so any summaries will include them.

Also if you're using perform grouping on server, this will write a better sql statement so the database will return data much faster.

I hope this resolves.

You'll get better tailored responses by thoroughly explaining your environment:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[Cretin]

he's right my issue was a bit dofferent each data row was a different detail section so it did work for me the other way was better

Cretin