Hi 
How can i avoide displaying ‘Query1: No data to fetch’. and i would like to display my user defined message.
I am running this report using paramenters (i.e. From date and To date)
could you please help me to resolve this issue.
thanks in advance
cheers
Nag
nagaraja.char 
(BOB member since 2003-01-22)
Hello Nag and Welcome to Bob! 
You have asked a very popular question 
. It is in our Reporter FAQ’s but unfortunately the answer hasn’t yet been written. I think you’ll find that if you try a search for the words ‘data and fetch’ that you’ll find plenty of helpful suggestions!
Cindy Clayton 
(BOB member since 2002-06-11)
Visit this link
reemagupta (BOB member since 2002-09-18)
Easiest would be to add a UNION to something that always returns one row of results that can be ignored (filtered out). You may have to create a bunch of “null” objects to complete the union (if you build this strictly in BO), otherwise you can manually modify the SQL to make it return a single row of “dummy” data from DUAL or another single row table.
-RM
digpen (BOB member since 2002-08-15)