Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Suppress Details based off Group Formula Post Reply Post New Topic
Author Message
FECSII
Newbie
Newbie
Avatar

Joined: 21 Sep 2009
Location: United States
Online Status: Offline
Posts: 22
Quote FECSII Replybullet Topic: Suppress Details based off Group Formula
    Posted: 11 Jan 2019 at 4:12am
I am trying to suppress the details section based off a formula in the group footer.

I am using the three-formula trick in my report; if the 3rd formula (placed in the group footer) equals 1, I would like the details within that group to be suppressed.

I tried entering {@3rd formula} = 1 into the section expert, suppress X+2 but doesn't evaluate correctly.

Any ideas how this can be done?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 11 Jan 2019 at 7:54am
Not sure what you mean when you say it does not evaluate correctly.  Is the formula not returning a  1 when you expect it, or it is and the suppress is not working?
IP IP Logged
FECSII
Newbie
Newbie
Avatar

Joined: 21 Sep 2009
Location: United States
Online Status: Offline
Posts: 22
Quote FECSII Replybullet Posted: 11 Jan 2019 at 7:56am
Sorry. The suppress does not work.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2019 at 10:50am
usually this is because the group suppression happens in an earlier pass then the value being generated by the formulas.
The usual process for group suppression needs to use a group summary.
What is the data and what is the suppression criteria?
IP IP Logged
FECSII
Newbie
Newbie
Avatar

Joined: 21 Sep 2009
Location: United States
Online Status: Offline
Posts: 22
Quote FECSII Replybullet Posted: 14 Jan 2019 at 4:22am
Hello - thank you for the response.

So, I created a formula (@first nine) that looks at the first nine numbers in field X. Field X contains a total of 11 numbers.

I grouped the report by the formula (@first nine).

Any records that may fall under the group that match the nine numbers displays, showing all 11 numbers.

Example:

111111119 Item XYZ


111111118 Item ABC
             11111111801 Item A
             11111111808 Item B
             11111111816 Item C

111111113 Item GHI


In this case, I would like to suppress 111111119 and 111111113 as there are no items that match the first nine digits.

Any suggestions on how to get this accomplished?



Edited by FECSII - 14 Jan 2019 at 4:23am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jan 2019 at 6:40am
a little confused b your request.
the fact that the row exists to create the group implies that each group has at least one row so how are their groups without details?...are you doing some sort of suppression process
IP IP Logged
FECSII
Newbie
Newbie
Avatar

Joined: 21 Sep 2009
Location: United States
Online Status: Offline
Posts: 22
Quote FECSII Replybullet Posted: 14 Jan 2019 at 8:11am
You are correct; I did not add any suppression - it looks like this:

111111119 Item XYZ
             11111111910 Item P

111111118 Item ABC
             11111111801 Item A
             11111111808 Item B
             11111111816 Item C

111111113 Item GHI
              11111111355 Item Z

Any group that has more than 1 record, I would like displayed, otherwise suppress.

Hope that makes sense.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jan 2019 at 10:31am
just do a straight up count at the group level of the formula field and suppress where the group count is >1

COUNT(@first nine,@first nine)>1
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Jan 2019 at 10:33am
you can also do a group select to exclude the group from the report on that same condition.
Just be aware for either that the hidden or group excluded data is still part of your data set for sums or counts or whatever.
IP IP Logged
FECSII
Newbie
Newbie
Avatar

Joined: 21 Sep 2009
Location: United States
Online Status: Offline
Posts: 22
Quote FECSII Replybullet Posted: 15 Jan 2019 at 4:01am
I was making it way more complicated then it needed to be. Thank you so much for the clarity. That worked as expected.
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.