Solved

crystal report section expert Suppress Checkbox and formula?

Posted on 2013-10-22
2
1,368 Views
Last Modified: 2013-10-23
I have a formula to suppress the section,  
When the suppress checkbox is checked, the report returned less rows than it's uncheked?

Could someone please tell me what the difference is?
thanks
0
Comment
Question by:HemlockPrinters
2 Comments
 
LVL 10

Expert Comment

by:ecarbone
Comment Utility
What is the formula you used in the suppress condition?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
What version of Crystal?

Can the database fields in the suppression be NULL?

The recommended practice with the checkboxes is to use the checkbox to ALWAYS in this case suppress.  If you want to conditionally suppress then leave the box unchecked and add the formula.

I have noticed a difference in how it works with a formula between when the box is checked or unchecked.  At first I thought the suppression formula was maybe working in reverse but now for the first time I think it might be that a field is NULL in the test.

When Crystal evaluates a formula with a NULL field unless the test in IsNull the evaluation terminates and the result is undetermined so in that case the check box setting might take over.

mlmcc
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now