How to supress a group base on a value 1

[Hm786]

Hi,

I need help on this report. I need to suppress a group based on the Share_reason fields value = 'DURING PROTECTION'

The data looks like this

0140701 R/T
0140701 OTHER

0140760 R/T
0140760 OTHER

0352700 R/T
0352700 OTHER

I want to show only these groups

0345300 R/T
0345300 DURING PROTECTION
0345300 OTHER


0353400 R/T
0353400 DURING PROTECTION
0353400 OTHER

0353401 R/T
0353401 DURING PROTECTION
0353401 OTHER

I need to suppress these groups having the DURING PROTECTION
How can I do this one please advice.

Thank You
Hamida

 

[Durango122]

hi
depending what version in crystal your using
the common way is to click on the top menu bar and select report and then selection formula -> record
in the formula editor enter
Share_reason fields value = "DURING PROTECTION"

Durango122

 

[synapsevampire]

Please take the time to post technical information.

When showing data, show the field names and data, and include your software version and database/connectivity.


If you data looks like the first set you show, how could the second have additional data? Perhaps there's a language barrier here.

Perhaps you mean that you WANT your data to look like this, but in the second set of data, this is what I currently have?

If so, go into the Report->Edit Selection formulas->Record and use:

{table.field} <> DURING PROTECTION

Hopefully this resolves.

-k

 

[Durango122]

hi
opssssssssssssss
hi
depending what version in crystal your using
the common way is to click on the top menu bar and select report and then selection formula -> record
in the formula editor enter
Share_reason fields value <> "DURING PROTECTION"

Durango122

 

[Hm786]

Hi,

My data looks like this
0140701 R/T
0140701 OTHER

0140760 R/T
0140760 OTHER

0352700 R/T
0352700 OTHER

0345300 R/T
0345300 DURING PROTECTION
0345300 OTHER

0353400 R/T
0353400 DURING PROTECTION
0353400 OTHER

0353401 R/T
0353401 DURING PROTECTION
0353401 OTHER


What I need is I want to show only these rows
0140701 R/T
0140701 OTHER

0140760 R/T
0140760 OTHER

0352700 R/T
0352700 OTHER

Where ever the DURING PROTECTION comes supress the entire group.
eg 0353400 R/T
0353400 DURING PROTECTION
0353400 OTHER

0353401 R/T
0353401 DURING PROTECTION
0353401 OTHER
supress.

Thanks,
Hamida

 

[lbass]

First insert a group on your column 1 field. Then create a formula {@duringprotection} in the formula expert:

if {table.share_reason} = "DURING PROTECTION" then 1

Then you can go to report->selection formula->GROUP and enter:

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

Alternatively, in the section expert, you could suppress the group header, details, and group footer, using:

sum({@duringprotection},{table.groupfield}) > 0

-LB

 

[Hm786]

Thank you Lbass, your suggestion worked like a charm.

And my special thanks to every body who responded to my question so quickly.

Hamida