Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Suppressing Post Reply Post New Topic
Author Message
AmandaH
Newbie
Newbie
Avatar

Joined: 17 Aug 2011
Online Status: Offline
Posts: 7
Quote AmandaH Replybullet Topic: Suppressing
    Posted: 19 Sep 2011 at 4:35am
Good morning,
 
I have a report that prints out invoices when patients owe a coinsurance on their account. We give them an estimate. The requestors would like any totals that are less than $10.00 to not print an invoice for them. What I did was go into Section Expert for every section and check the Suppress box then entered this formula:
 
{@Patient Estimated Responsibility 2} < 10.00
 
The @patientestimatedresponsibility2 is a formula where we calculated deductible, coinsurance, oopm, etc to get the patient responsibility. This suppression works fine and dandy for majority of the invoices, but then it starts printing the header on one invoice twice which moves the details to another page. Is there something I'm missing? Any help or suggestions are much appreciated. Thank you!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Sep 2011 at 4:55am

to trouble shoot you can insert the {@Patient Estimated Responsibility 2}  field into the header add see what is being displayed for the records that are not suppressing correctly.

THis may give you a clue as to where the problem is.
IP IP Logged
AmandaH
Newbie
Newbie
Avatar

Joined: 17 Aug 2011
Online Status: Offline
Posts: 7
Quote AmandaH Replybullet Posted: 19 Sep 2011 at 5:16am

Thanks for the tip!

Weird that when field is placed in the Page Header it matches the total in the Page Footer A sometimes and other times it is shows $0.00. I have RunningSum formulas and ResetLiCounts formulas in the Page Header as well... could this have something to do with it?  
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Sep 2011 at 6:41am

Running totals (shared variable versions or the Crystal's actual RTs) do not work in headers. They will only show you the value from the first row of the group. That may be what you expected to see and appears to 'work' but that is only by chance that you only include the first row not becuase it was actually working. To suppress groups headers you have to be able to a summary that you could have created using the insert summary function. These can be placed in headers and will show you the correct value for the group consistently.

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.029 seconds.