Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Total from Subreport Post Reply Post New Topic
<< Prev Page  of 3 Next >>
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:03am
Good Morning DBlank, thank you for the reply. Yes I am suppressing from the subreport value which is passed into the main report.   The subreport is in the group header.   I actually entered the values for the field and it is showing correctly, only the detail is showing too. only on some.   What would my formula look like ?   Thanks.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Nov 2016 at 3:09am
please explain your set up, something like this

GH1a: subreport
GH1b: shared variable placement in main report
GH1c: conditionally suppressed group header data
details: conditionally suppressed
GF1: conditionally suppressed

Edited by DBlank - 14 Nov 2016 at 3:09am
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:21am
GH1a: subreport
GH1b: shared variable placement
Details: conditionally suppressed based on shared var.
GF1 Totals
(I have no group header data to suppress.)

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Nov 2016 at 3:25am
and you are only trying to suppress the detail sections?

Take your suppression criteria from the details section and copy it into a new formula field (like 'suppress_test') and place it in the detail section to see if it shows a T or F
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:26am
sorry. i am trying to suppress the detail and the GF sections both.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Nov 2016 at 3:28am
ad the 'suppress_test' formula to both sections to see what it is doing
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:28am
Also, what would the formula look like.   all my detail section shows is mainformula=0
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 14 Nov 2016 at 3:30am
that is all you would add then
it will return a true or false (or possibly a NULL).

another possibility is that you are seeing zero but it is actually something like .0000000000001 so it is technically not 0.
try the suppress formula first
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:33am
i'm sorry...not sure if i'm doing this right.

so my formula would look like this:

SuppressTest

mainformula=0

or do i need to add a suppress comment somewhere in the formula ?
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 14 Nov 2016 at 3:34am
o.k. i did that and it is saying false on every detail section...
IP IP Logged
<< Prev Page  of 3 Next >>
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.016 seconds.