Hiding Default messages

building reports desktopintelligence
1

Hi :confused:

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 :india: (BOB member since 2003-01-22)

2

Hello Nag and Welcome to Bob! :mrgreen:

You have asked a very popular question :yesnod: . 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 :us: (BOB member since 2002-06-11)

3

Visit this link

reemagupta (BOB member since 2002-09-18)

4

[quote:60125acd6e=“nagaraja.char”]
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)

[/quote]

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 :us: (BOB member since 2002-08-15)