How To Hide No Data Selected Message

Viplove G Gawde

Member
Hi,
I have a requirement where Client Demands to print Nothing to report Instead of No Data Selected when data is not selected.
Any Body Knows How to do this
confused.gif
 
I have always wondered this myself but never enough to look for any kind of a configuration paramater or anything.

The follwoing is the only thing I can think of off hand (that is unless someone knows of a setting or something... which would be useful to know). Note I have not actually tried this, just the only thing I can think of.


1. Make the section conditional.

2. Using the following C API, create a BSFN to check first to see if the
report section is going to return a results set and only call the section if it will return records.

ubeSection_GetDataSelection
JDB_OpenView <<< opening the same view as the UBE section
JDB_SetSelectionX <<< using the return from ubeSection_GetDataSelection
JDB_SelectKeyedGetCount <<< number of records that will be returned
ubeSection_FreeDataSelection


Downsides to this are:

1. Runs two SQL commands. Granted the BSFN one doesn't return the full recordset, just a record count, but still is an additional load on the DB server.

2. This is on a ube by ube basis and would require some time to code. If you are looking for a quick universal solution... this is NOT it.
 
In RDA, it is possible to use Event Rules to selectively 'Suppress Section Write'; this will still create an output with a page header and blank page.
 
Back
Top