Hide a subreport based on the value

[DeveloperSteve]

I have a main report with a subreport in the detail section. If a control on the subreport has a value of zero I'd like to set the subreport to visible = false. The control on the subreport is an unbound calculated textbox. This sounds simple enough, but the solution has eluded me so far.

 

[Angelflower]

Did you ever figure out how to do this? I am working on the same thing and having no luck.

Thanks!

 

[Simon_MT]

The solution maybe data centric.

In your subreport use a query and put your calculation into the query. Then in the Criteria <> 0.

On the report set the subReport Height = 0 and Can Grow = Yes

Simon