Solved

crystal report section expert Suppress Checkbox and formula?

Posted on 2013-10-22
2
1,414 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
ID: 39592960
What is the formula you used in the suppress condition?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39593070
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
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…

776 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