BusinessObjects Board

Is there a way to not display 'No data to retrieve'

Hi,
After entering value in the prompt and refresh the report if there is no data for the value enetered then BO displays ‘NO data to retrieve’ message.
Is there a way, so that we will not get this message.

This helps me to have my own message displayed on top of the report table.

Please help me to get rid of this message when there is no data to retreive.

Thanks for the help.


tsr_bo (BOB member since 2008-06-13)

Great post on the various options here:-

https://bobj-board.org/t/72584/17


Mak 1 :uk: (BOB member since 2005-01-06)

Mak,
This will effect all the other users also.I am looking for a solution without changing any .jsp or .asp codes.

I remembered reading it in this forum long time back, if we try to get some dummy data in the query( we will not display it in report) then we can remove this error.But i forgot the logic for this.
Is there anyway you remembered it?

Thanks for the reply and the help.


tsr_bo (BOB member since 2008-06-13)

Couldn’t you just return a column with a textual value literal, defined in the universe, I haven’t tried this, but with other valid objects, it could work?


Mak 1 :uk: (BOB member since 2005-01-06)

I thought of the same and tried it but of no success.
do you have steps to implement this OR any other logic?


tsr_bo (BOB member since 2008-06-13)

Try the FAQ:-

https://bobj-board.org/t/15226/19


Mak 1 :uk: (BOB member since 2005-01-06)

Mak,
I created dummy object(char) that returns empty value and used in the union of the report query. It is working fine now.

Previously i forgot to put ’ ’ for dummy object as it is char.

Thanks a lot for all your help.


tsr_bo (BOB member since 2008-06-13)