Crystal Reports Suppressing a group (header and records)

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Suppressing a group (header and records)

Post Reply

Post New Topic

Author	Message
Matteo_Luccio Newbie Joined: 30 Jul 2013 Location: United States Online Status: Offline Posts: 9	Topic: Suppressing a group (header and records) Posted: 14 Aug 2013 at 6:42am
	In my current report, two of my fields are "job" and "operation_service". I am grouping on "job". I want to suppress every group (meaning, both the header and all the records in that group) that does not have at least one record in which the "operation_service" field contains a certain code. Any ideas? Thanks!
	Matteo Luccio, President Pale Blue Dot, LLC Writing about geospatial technologies since 2000 www.palebluedotllc.com 541-543-0525
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Aug 2013 at 7:40am
	create a "flag" formula // if field.operation_service <> code then 1 sum this at the job group sum(@flag,job) Now any group that meets your condition has a value>0 and the ones you want to suppress = 0. You can suppress them with sum(@flag,job)=0 or you can use the group select to exclude them sum(@flag,job)>0
	IP Logged

Matteo_Luccio Newbie Joined: 30 Jul 2013 Location: United States Online Status: Offline Posts: 9	Posted: 14 Aug 2013 at 7:56am
	Excellent, thanks!
	Matteo Luccio, President Pale Blue Dot, LLC Writing about geospatial technologies since 2000 www.palebluedotllc.com 541-543-0525
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum