Suppress blanks in a formula or skip logic
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=801
Printed Date: 04 May 2025 at 8:37pm
Topic: Suppress blanks in a formula or skip logic
Posted By: weered1
Subject: Suppress blanks in a formula or skip logic
Date Posted: 06 Jun 2007 at 1:05pm
|
I have a list of values with associated currency amounts:
The Arts $5,000
Theatre $1,500
Computers $10,000
Business $2,000
etc...
I need to only list certain values, but I still need to be able to use their currency amounts on my report to add to the listed amounts:
The Arts = The Arts + Theatre currencies (total of $6,500)
When I use record selection to leave out "Theatre", I can no longer add its currency to "The Arts". If I leave it in, I cannot seem to skip over it in the Details section.
I tried inserting the values into a text object and selected "Suppress blank imbedded values", but that doesn't seem to work. I have a formula like the above one to add the currencies together, but then I need to leave the Theatre line out of my report.
Is there anyway to manage this in Crystal? Can I use some sort of skip logic (If{value}="Theatre" then skip)?
Thanks for your help. I hope this wasn't too confusing.
|
Replies:
Posted By: BrianBischof
Date Posted: 06 Jun 2007 at 2:20pm
|
You can right-clicki on the Details section in the grey area and choose Section Expert. Then modify the Details section using a conditional formula for the Suppress property. Check the field's value and suppress the details section when necessary. It will still include the value in the summary total since the data gets read in the first pass of the report, but it won't show the record on the page.
------------- Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a> |
Posted By: weered1
Date Posted: 07 Jun 2007 at 5:33am
That worked- thank you so much! 
|