Home > Default > If NO_DATA_FOUND then want to print message instead layout

If NO_DATA_FOUND then want to print message instead layout

October 11Hits:0
Advertisement
The report has dynamic query, which is built on base of parameters passed by USER at run-time.
Suppose if no data is returned for that query, (1)how can I avoid printing regular titles and (2) print some other message saying data is not found.
Thanks,
Nirav

Answers

On your data model, create a report-level summary column that counts some column in your report. Then, on the layout model, create a boilerplate text containing the message that you want displayed when there are no records fetched. Then create a format trigger for the boilerplate that suppresses it when there are records, but displays it when there aren't. ex:
if :summary_column is null then
return true;
else
return false;
end if;

Read other 6 answers

Tags:

Related Articles

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.653 s.