Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Ignore, Not Suppress, Group Post Reply Post New Topic
Author Message
bshort1023
Newbie
Newbie
Avatar

Joined: 18 Jan 2012
Location: United States
Online Status: Offline
Posts: 18
Quote bshort1023 Replybullet Topic: Ignore, Not Suppress, Group
    Posted: 02 Oct 2015 at 9:43am
I have a report with three grouping levels:
Country
  Industry (i.e. Steel, Aluminum, etc...)
    Customer

I give the user a parameter to allow them to suppress the Industry group.  I do this through Section Expert.  It looks like it works but it really only suppresses the group header.  It is still grouping the Customers by Industry.  So instead of seeing a complete alphabetical list of Customers grouped by Country I see an alphabetical list of Steel Customers and then an alphabetical list of Aluminum Customers with no break between because the header is suppressed.  What I would like to do is ignore the Industry Grouping all together so I would just see a list of Customers grouped by Country.

Thanks,

bshort1023

IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 04 Oct 2015 at 10:07pm
Hi,

Create a Formula for Group 2 as below:

WhilereadingRecods;
If {?Suppress Parameter} = "NO" Then
{Industry_database_Field}
Else
""

Instead of creating Group2 on database field use above formula and use the same suppress formula for hiding the group2 headers.

--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
bshort1023
Newbie
Newbie
Avatar

Joined: 18 Jan 2012
Location: United States
Online Status: Offline
Posts: 18
Quote bshort1023 Replybullet Posted: 06 Oct 2015 at 2:19am
Ah so I was suppressing based on the formula but I should have been grouping based on the formula.

Works great!  Thanks!
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.