Conditional Element on Report

kklosson

I want to print a text element on a report based on whether or not any child records exist related to the object of the report. For example when no Purchases exist for a Customer report. In a process, I could use:

IF Customer.Purchase IS UNDEFINED THEN...

This does not seem to work in the condition for a report element. I also tried to use ELEMENT_COUNT, but in reading the docs, this does not seem to be useful here.

Any thoughts?

Jaymer

If You can put that conditional text element online by itself, then print it via a sub report.
Use a FIND to locate the Child.
For the sub report check the option that says don’t print if no data exists/something like that.
Have sub report trim down to just print that static text and then it exits.

kklosson

Thanks. It so happens this is a subreport. This element is in the Title band and the subreport is set to print all but the detail band if the report is empty.