In WEBI XI R2 ,when we run a report and if there is no data corresponding to the query we give,it displays"There is no data corresponding to this query".But i want a report always be produced even if there is no data for the period. Customized message should read in the report.But not as a message box.
How can i do it?
srilakshmi.bandla (BOB member since 2010-01-26)
Thank u Jhansi.
Some part of it did help me,but no completely,because i dont have access to neither database nor to universe.
I just put a heading with some message if there is no data,but couldn’t remove the no data to fetch message.
Thank you though.
regards,
Sri.
srilakshmi.bandla (BOB member since 2010-01-26)
There was a link in that post to the FAQ 
, I have posted this below .
Try looking at the union query solution.
https://bobj-board.org/t/15226/29
Mak 1 
(BOB member since 2005-01-06)
To use the union query solution,as i said i don’t have access to neither database nor to the universe.
srilakshmi.bandla (BOB member since 2010-01-26)
Well, by been inventive, I believe, you could still get this to work :).
Someone must have it, universe access, in your organisation, it depends on how badly you want this to work, I guess.
Mak 1 
(BOB member since 2005-01-06)
I dont think it is that badly needed that they will give me acess to universe.
Thank u 
srilakshmi.bandla (BOB member since 2010-01-26)
No problem!
If you can union a query that contains a single row, or even more, with valid objects, you could filter it out of the block result.
As I said, you could get inventive…:).
Mak 1 (BOB member since 2005-01-06)
(BOB member since 2008-05-12)