?
Solved

crystal report section expert Suppress Checkbox and formula?

Posted on 2013-10-22
2
Medium Priority
?
1,531 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Expert Comment

by:ecarbone
ID: 39592960
What is the formula you used in the suppress condition?
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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