Hi,
We are creating a web app which will invoke various IBI reports, by clicking a button. When the button is clicked, an IE window opens up, the report runs and then Excel opens up and report is loaded. Is there a way to not have that IE window open? If users run 10 reports, they will end up with 10 IE windows, all empty.

Has anyone found a workaround for this, somehow not opening those IE windows, or hiding them?

Thanks,
Luminita

This message has been edited. Last edited by: Luminita,

Can you use compound reports, all the reports could be returned in one Excel document.

Check/change your redirect settings. Many posts on those settings - search for redirect xls xht.

T

We already tried rederection with no luck. Do you know if there is a way to add a javasript to tell the page to close after a certain number of seconds?
L-

Is it only Excel or is it PDF as well?

PDF can be changed with Acrobat Reader settings - on each users machine unfortunately - by checking the "Display PDF in Browser" under the Internet settings within Edit/Preferences.

There will be something similar to "encourage" Excel to use the browser plugin.

T

This message has been edited. Last edited by: Tony A,

Hi,
One of the guys I work with found a workaround for the opening of multiple IE windows: using Javascript we just reuse the same window when running the reports. At least this way we don’t end up with a bunch of empty IE windows. This code is in the webapp that invokes the reports.

  
/**
 * Opens a popup window for the url passed in.
 * 
 * @param url
 * @return
 */
function downloadReport(url)
{
      var width  = 300;
      var height = 400;

      closeWindows();
      standardDownload = window.open(url);
      standardDownload.focus();
      trackOpen(standardDownload);

}

var openWindow = new Array();

/**
 * Track open adds the new child window handle to the array.
 */
function trackOpen(winName) {
  openWindow[openWindow.length]=winName;
}

/**
 * loop over all known child windows and try to close them.  No error is
 * thrown if a child window(s) was already closed.
 */
function closeWindows() {
  var openCount = openWindow.length;
  for(r=0;r<openCount;r++) {
      openWindow[r].close();
  }
}