Crystal Reports Supressing A Group

Report Design

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

Topic: Supressing A Group

Post Reply

Post New Topic

Author	Message
Kurab Newbie Joined: 30 Apr 2008 Online Status: Offline Posts: 1	Topic: Supressing A Group Posted: 30 Apr 2008 at 8:50am
	Here is my problem - I have a group of data for check warnings when a item does not clear. Once this problem is corrected a additional line is added saying the problem is corrected IE: Group A Problem Problem Problem Problem Solved If the details contains the problem solved line I want to suppress the entire group. Thanks in advance.
	IP Logged


Seva Newbie Joined: 01 May 2008 Location: United States Online Status: Offline Posts: 10	Posted: 02 May 2008 at 11:28am
	Four parts solution: 1 Create Formula Field{@NumForFilter}: if TabLeName.Field = "Problem Solved" then 1 else 0 2. Place this Formula field in Detail Section 3. Summarize this Formula field on Group Level 4. Go to Select Expert -- Show Formula -- Group Selection, and place formula into editor: if Sum ({@NumForFilter}, {Group}) < 1 then true else false In this case your Report will exclude all Groups where "Problem Solved" value has been entered. Thanks, Seva
	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