Supressing sub reports?

[gtjr92]

I have a report with 2 sub reports if a particular field is null then I want one of the sub reports supressed and not run at all. If another field is null then I want the opposite subreport suppressed. I have the 2 reports in seperate detail section of the main report. I right clicked on format section and clicked suppress and put in this formula
isnull({WORKORDER.WOCIRC}) or {WORKORDER.WOSTAT} = 'X'
I have a similar formula in the details section of the other report. I have tried this with the suppress box checked and unchecked to no avail. These sub reports conflict with each other if certain fields are null and do not give proper data (if any) if they both run at the same time. Why are the reports not being suppressed?

Thanks!!!!

 

[synapsevampire]

Your logic seems sound to me.

You should NOT have to click the suppress check box.

Test by creating a formula of each suppression condition and displaying it in it's section.

Also, does the subreport return a shared variable, or does it display data? Subreports can do odd thigns, so apply the service pack as well:

http://support.businessobjects.com/fix/hot/si75/default.asp

I would test the first one first, once you get it working go on to the second.

-k