Supppressing Data

[sam1one]

How would one suppress data for a group in Crystal Reports 8? I am able to actually suppress the group name, but need to do the same for the group.

Thanks,

sam1one@yahoo.com

 

[synapsevampire]

You need to post meaningful information:

Database/connectivity used
Example data
Expected output

To suppress data, use the Report->Edit Selection Formula->group

An example of a group suppression would be those with some value requirement, which might end up as a formula like this:

sum({table.qty},{table.groupbyfield}) > 1000\

-k

 

[Tamrak]

I have a similar situation. What I would like to do is to suppress the group and the data.

The condition is, if the group DOES NOT start with letter "P", suppress the groups and their data. I would like to show only the groups that start with letter "P", with their data. I used the left function, 1 = "P". It seems to work on the group, but not the data.

I think I have to do something at the formula level. I am unsure whether to do it at the details or at the group.

I do appreciate your response. Thank you.

 

[lbass]

Instead of suppression, you could use group selection. Go to report->edit selection formula->GROUP and enter:

{table.groupfield} startswith "P"

However, the suppression approach should work as well. You would use something like:

not({table.groupfield} startswith "P")

Use this in the section expert for the group header, footer and detail section->suppress->x+2. If this still doesn't work then maybe you have spaces or lower case letters that you have to accommodate, by using:

not(trim(ucase({table.groupfield})) startswith "P")

-LB