"Crystal Reports 2008 Experts"


Is it possible to suppress a subreport that is within a main report by using record selection formulas / booleans (true/false scenarios)?

For example:
If IsNull({database.field})
Then
True
Else
False


Any help would be great!
I'm trying to get around creating multiple customized reports for my department's needs.



Thanks

Stephen Waichulis

Right click on the subreport and click on menu "Format Subreport". A dialog box will be shown, find the check box "Supress" and click the related button "X+2" ( on the right side) - you can write your formula in the formula editor which will be shown .

www.R-Tag.com Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

Hello RTag,
Thanks for responding.

I need to control the suppression of the entire subreport from the main report.
I was trying to control the suppression of my subreports by writing syntax within the subreports and this still generated lots of blank white space.

My intention is to create a parameter that will prompt the user to say yes or no for certain subreports to run/show. The parameters need to be controlled by a boolean / true/false option that would essentially suppress the entire subreport if certain testing was not performed by our LAB.

I believe creating a parameter is the answer to what I'm attempting to do.
I'm just not sure how to link this parameter to the subreports I wish to show or hide.

Stephen

Please do NOT cross post--there are now six posts instead of the one you needed.

-LB

No, i'm wrong. There are about five sets of two of the same posts! Please do not do this again.

-LB