Conditional Report Display Based on Dynamic SQL Query
679690Feb 26 2009 — edited Mar 3 2009Hi All,
I have a page that contains 2 regions, 1. ) An HTML Region that contains the page items used to enter the search criteria. 2.) A report that is based on a PL/SQL function body returning SQL query.
I am trying to set the conditions on the report to display only if results are returned from the query. I added a Go button, and set the report condition to Request=Expression 1, and Expression 1 was set to "Go". No results were returned, but if I removed the condition the results would display.
Can someone please explain how to set the conditions on the report to only display if the query results return true?
Thanks,
Keisha