Disabling/removing the "No data to fetch" message

system · October 20, 2006, 9:19pm

Hi friends,

Quick question: When a query returns empty, it says “no data to fetch” or similar and one has to press the OK-button. Is there any way of disabling this feature such that if a query returns no data, then it does not notify you?

thanks,
plexi 8)

pleximax (BOB member since 2004-08-20)

system · October 20, 2006, 10:44pm

Have you searched for this? This has been asked/answered at least 100 times.

No, there is virtually nothing you can do for this. If you use scripting to turn off messages, then your prompts won’t come up.

You don’t have this problem if you refresh via InfoView.

Steve Krandel (BOB member since 2002-06-25)

system · November 30, 2006, 6:07am

Hi Steve,

Can you please breif how it can be done in Infoview. I am using WebI -Xi -R2. As far as know, I can’t use macros… so scripting language will not help here.

All the answers are here for full client not for WebI.

thanks in advance.

Selva.

selvaips (BOB member since 2005-05-03)

system · November 30, 2006, 6:17am

try to use macros of desktop intelligence if you are using XIR2.

venira (BOB member since 2004-12-07)

system · November 30, 2006, 9:01am

Hi,

you meant have a macro written in full client and use this in WebI? Yes, I am using Bo-Xi -R2(WebI). How it can be done? How can I call the vb macros into the WebI?

As far as I know, macros cannot be used in the WebI? Am I right?

Regards,
Selva.

selvaips (BOB member since 2005-05-03)

system · November 30, 2006, 2:55pm

I am also having exactly the same problem. I am also using webI XI R2.

Guys lets share your expertise.

thanks,
J WOOD

wood (BOB member since 2006-06-05)

system · November 30, 2006, 4:50pm

I have not seen any solution to this for XI. Nothing (not even a case) is posted on the BO site.

Steve Krandel (BOB member since 2002-06-25)

system · December 1, 2006, 2:02am

Hello,friend:
I am using webi xir2.If you are a XI server manager,you can get the viewer.js by the following way…(supposing you are using viewer in english)

<webserver>\webapps\businessobjects\enterprise115\desktoplaunch\viewers\cdz_adv\language\en\scripts\viewer.js

and you search the following code in this file

function displayNoDataToFetch(s,cb)
{
showAlertDialog("No data to retrieve in "+s,"Retrieving Data",0,cb);
}

then change it to

function displayNoDataToFetch(s,cb)
{
//showAlertDialog("No data to retrieve in "+s,"Retrieving Data",0,cb);
}

finally,the dialog wont display!

Good luck.
megan.

megan (BOB member since 2006-10-27)

system · December 1, 2006, 6:23am

Thank you Megan…

It’s really a good infiormation… Just comment the line is enough or the script needs to be compiled and executed? Since it’s a code written in java, it hsould be compiled. For that I need SDK. Right? Correct me If I am wrong. Simply comments the line will not be sufficient.

Please confirm.

Selva.

selvaips (BOB member since 2005-05-03)

system · December 1, 2006, 6:29am

No. It’s JSP. Change the code, bouce Tomcat and you’re off.

Right?

Steve Krandel (BOB member since 2002-06-25)

system · December 1, 2006, 7:37am

thanks Steve. It’s really interesting to see play with the architecture. Getting excited to see this. Feel like one step ahead on BO stuff.

Just gonna to try this and let you know If I am successful.

Selva.

selvaips (BOB member since 2005-05-03)

system · December 1, 2006, 7:40am

hi,selvaips

The code is writen in javascript,you don’t need any SDK to make it work but just comment the code.I think BO use javaBean or servlet to call displayNoDataToFetch function,so you have to comment the body of this function in viewer.js file,Then the function will do nothing.

Good luck.
megan.

megan (BOB member since 2006-10-27)

system · December 1, 2006, 11:55am

Thank you Megan…

I have one more doubt. I am able to see the same file in another location which is :

C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Web Content\Enterprise115\InfoView\Webi\viewer\language\en\scripts

What’s the different between these two files. One is coming from the webserver and one from above mentioned location.

Which one needs to be updated?

Also, if I want to achieve this for full client? Is that one ies enough? Or Do I have to see somewhere else?

Any idea?

Selva.

selvaips (BOB member since 2005-05-03)

system · December 1, 2006, 3:39pm

Hi megan,

Thanks very much . It worked beautifully.

thanks,
J WOOD

wood (BOB member since 2006-06-05)

system · December 1, 2006, 4:20pm

Hi There,

But disabling this would disable all empty messages for all Business Object Reports. Am i right? Is your requirement for that particular report only?

thanks,
antzcp04

antzcp04 (BOB member since 2006-08-04)

system · December 1, 2006, 4:31pm

Is there any way i can stop this for a single report?

This will be great help.

wood (BOB member since 2006-06-05)

system · December 1, 2006, 4:39pm

What i can think of to try to retrieve the unique key in that report and add additional script on the function to disable it only in the report…So basically you have to do a if else

thanks,
antzcp04

antzcp04 (BOB member since 2006-08-04)

system · December 1, 2006, 5:12pm

This only affects reports being refreshed through InfoView. I think this is a good idea all the time. Only developers using the WebI panel or DeskI client should need to know there was no data.

Steve Krandel (BOB member since 2002-06-25)

system · December 1, 2006, 6:08pm

It only affects when we open report by clicking on reports name. If we open report being developer(i mean clicking on modify button) we still see pop up saying “No data to retrieve” message if there is no data.

wood (BOB member since 2006-06-05)

system · December 1, 2006, 6:46pm

Exactly! To be honest, developers shouldn’t care. Users are the ones who don’t get it.

Steve Krandel (BOB member since 2002-06-25)