Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Can't get this to suppress right. Post Reply Post New Topic
Page  of 2 Next >>
Author Message
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Topic: Can't get this to suppress right.
    Posted: 18 Nov 2016 at 6:23am
I am pretty new to crystal, but my boss wants me to modify a report for use in the company. I have made a lot of progress just by messing around with different options but I am now hitting a road block while trying to get the proper information to suppress while not suppressing the other data. Please help.

This is a picture of what I am trying to do.

Also, can I attach a photo directly from my computer or do I need to host it online before I can share it? Sorry dumb question.




Edited by Doolhoff - 18 Nov 2016 at 7:21am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Nov 2016 at 8:36am
consider a conditional suppression using the inventory Ref field
something like
not onfirstrecord or previous(table.inventoryrefnum) = table.inventoryrefnum
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Posted: 18 Nov 2016 at 8:41am
I will give it shot and let you know.
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Posted: 18 Nov 2016 at 8:51am
So it worked, kinda. It did suppress what I wanted but also WAY more than needed.

Here's a photo:



Edited by Doolhoff - 18 Nov 2016 at 8:53am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Nov 2016 at 9:15am
Did you place the suppression formula only on the qty field? That was where it should go, not on the section.

Edited by DBlank - 18 Nov 2016 at 9:16am
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Posted: 18 Nov 2016 at 9:37am
So, not in section expert..? Sorry, like I said, I'm still kinda new to crystal.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Nov 2016 at 10:20am
Right click on the quantity field
Select format field
Select the suppress formula button
Place the formula in there
Test it out

Edited by DBlank - 18 Nov 2016 at 10:21am
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Posted: 18 Nov 2016 at 10:37am
Here is what happens:



Edited by Doolhoff - 18 Nov 2016 at 10:38am
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 22
Quote Doolhoff Replybullet Posted: 18 Nov 2016 at 11:36am
So I just found that I have been trying to suppress the wrong table inside the formula field. I am now encountering an issue where the first item, no matter what is before it, has the quantity suppressed.

I think I am on the right path. Thank you so much for your guidance DBlank!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Nov 2016 at 11:41am
use the
"not onfirstrecord"

otherwise the previous(field)<> field will suppress it because is comparing nothing to somehting which is not the same and suppresses it.
IP IP Logged
Page  of 2 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.017 seconds.