I have my report set to output to Excel. When I run it, it give the saves as option for Excel before I can open it. How can that be turned off so I can just open the output?

Thanks

This message has been edited. Last edited by: <Emily McAllister>,

Hi cleming,

Can you give me more details about what you mean? How did you make this report? Do you mean that WebFOCUS is prompting you at runtime to choose a format, or that your browser prompts you to Open or Save As the resulting file?

Thanks,
Emily McAllister
Focal Point Moderator

The browser prompts you to either Save or Open the file. This is the normal behaviour of WebFOCUS XLSX format. Now, let's see if anyone can tell you how to have the file open automatically.

It happens with EXL2K as well when opening in Excel 2010. I always thought this was a function of the browser or Excel (we are on IE 11). I haven't tried with another browser.

quote:

Now, let's see if anyone can tell you how to have the file open automatically.

That would be nice...

Redirection Settings...

Tom, I played with them a bit, without positive results. Just wondering if you successfully changed the redirection settings and made it work?

Hi Francis,
Yes, screenshot below. Now, it does come up where we have to "Enable Editing", but, no save or open.
We also use an ASNAME to give it a viable report title, kinda:

  
TABLE FILE CAR
ON TABLE SET PAGE-NUM OFF
SUM RC AND DC AND
COMPUTE PROFIT/P12.6 = (RC - DC) * .43567;
BY CAR
HEADING
"Profit By Car"
" "
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD AS 'Car_Report' FORMAT XLSX
ON TABLE SET STYLE *
TYPE=REPORT, COLOR=BLUE, BACKCOLOR=SILVER, SIZE=9,$
TYPE=HEADING, STYLE=BOLD, SIZE=14, $
TYPE=TITLE, STYLE=BOLD, SIZE=11,$
TYPE=GRANDTOTAL, STYLE=BOLD, SIZE=11,$
ENDSTYLE
END
-EXIT

BTW, if I recall, the Save/Open box has a check box where it says always open in Excel - that box does need to be checked...

Tom, I don't see the screen print of your redirection settings.

Hey jg,
How about now? Using Tinypic...

This doesn't appear to work in WF8.0.08 and IE11. I set all Excel related extensions to yes, yes, cleared the cache, restarted Tomcat, but I get the same result - a popup at the bottom of the IE11 page:

Sorry to see that Francis. May be the way the browsers are now downloading. Not used IE11.
1 extra click then, oh well!

It's also possible this is due to Windows Group Policies set by the administrators.