Using Formula to suppress a section 1

[rfoote]

I have a report that need to be either a summary report or a detailed report. I do not want have to maintain 2 reports for this so I added a paramater called print_detail.

Then in the format section for the detail section - Suppress I have it not checked, but within the formula I put
if print_detail = "Yes" then
False
else
True.

The results to not change

I am running version 8.5

Thanks for your help.

 

[synapsevampire]

First, just use:

print_detail <> "Yes"

This will suppress when they don't select yes.

Also consider that a summary report can pass the GROUP BY clause to the database, so trying to create a mixed use report will result in the details ALWAYS being returned, hence slower performance when you only want a summary.

-k

 

[rfoote]

Thank You some times the programmers forget about the simple steps with the application.

Thanks again.

 

[harrietohs]

I just want to say a big thank you to both the person who posted this question and the expert who answered it. I had no idea I could do this and it is a wonderful thing!

I actually just used the formula to conditionally suppress a field in a cross tab report and it worked like a charm!

Thanks again for figuring out what I needed before I knew it myself!

Harriet

 

[dgillz]

Harriet,

So if you liked the post, give them a star. Look in the lower left hand corner of the posts in question.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz