Solved

crystal report section expert Suppress Checkbox and formula?

Posted on 2013-10-22
2
1,390 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
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 …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

15 Experts available now in Live!

Get 1:1 Help Now