Need Custom Error message in case report runs blank SAP BO 4.2

[former_member538282]

Hi,

My report has 2 Queries with 6 mandatory prompts and 18 optional prompts.

We have a requirement where in case if report runs blank, then instead of showing the display message as "No Data to retrieve in Queryname", is it possible to have a message like "Prompt name does not hold any matching value in Queryname"?

Thanks in Advance.

[bernhard_keimel]

you cannot disable or customize this message, this is by design

What you can do is to assure on universe level or report query level that in case no data is returned, a dummy row is generated that holds your custom message.

F.i. make a UNION query where this message is generated. Depending on the query you can find a way that this union path only contains a row if the other part does not, but thats very depending on the database you use as datasource and the skills of the report developer.

If you need that for all reports, maybe it is good to implement that in the universe.

So the answer is: no, not possible to get rid of this "no data" message, but you can take action in the query and/or universe to assure that there is always data returned