Hi,
I have a report that uses 4 data providers. When there is No Data to
retrieve from the database,the ‘No Data to Fetch’ message is shown 4 times
(because there are 4 data providers) .
Is there a way I could bypass this message or avoid the message
being shown 4 times?
I want the message to be displayed only once.
Thanks in advance.
amsmi 
(BOB member since 2006-09-08)
Please search in the forum before you post, many of such issues are previously been answered.
How about this Report FAQ entry:
https://bobj-board.org/t/15226/19
Hope it helps.
BO_Chief 
(BOB member since 2004-06-06)
Keep in mind that if the report is refreshed by uesrs via InfoView, the messages will not show up.
Join the 21st century and ditch giving out the client.
Steve Krandel (BOB member since 2002-06-25)
We usually to that like this f.i.:
Select
dgz_pa_bereken.rq,
dgz_pa_bereken.st,
dgz_pa_bereken.st_description,
dgz_pa_bereken.pa_description,
dgz_pa_bereken.pa_gemiddelde
from
dgz_pa_bereken
where rq =@variable(‘rq_rq’)
union
Select
atsystem.setting_value labo,
null rq,
null st,
null pa_description,
0 pa_gemiddelde
from atsystem, dual
where atsystem.setting_name =‘CURRENT_DBNAME’
This results always in at least 1 row in DP
johangel (BOB member since 2003-03-23)
thank u…
amsmi (BOB member since 2006-09-08)