Focal Point
Excel sorting functionality problem

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5091083071

June 02, 2006, 02:59 PM
Amy
Excel sorting functionality problem
Many of our users have Office 2K or higher. When a WebFOCUS report is run and is to output the results into Excel, they do not have basic excel functionality without first saving the report then reopening. Has anyone found a way to solve this? It seems to have this problem a lot less. We are using the MRE environment, not the dashboard.
Thanks!
June 03, 2006, 02:11 PM
susannah
Amy, that's right, thats just the way it is.
If you can attend this Friday's webseminar that is advertised on the sticky post on focalpoint, then you can ask Brian Carter directly to explain all that to everyone.
There is actually a benefit to this..although it might be hard to see it as such...
you can bring an excel report , pivot table and all, into an output frame on your website, and allow users to work the pivot, enter data for formulae, etc, directly on the web, without having to invoke full excel. hard to explain, but can have a huge wow factor on a website.
Little solice, when you're presenting your output in its own new window (vs a web frame) , and are expecting a complete excel sheet.
-S.

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




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
June 06, 2006, 04:30 PM
debbiej
If you're not working with web pages, go to Windows Explorer, Tools, Folder Options, File Types, scroll down to the .XLS file type, highlight it, click the ADVANCED button and UN-CHECK the 'Browse In Same Window' selection. This will cause your Excel Output to launch in "real" Excel instead of just opening the Excel sheet in the browser (with limited functionality). UPDATE . . . Each User will have to do this on their machine . . .

If, as Susannah says, you are working with Excel in Web Pages, you will want to have the Browse In Same Window option checked, so you do lose the "real" Excel functionality.

Deb


WebFOCUS 7.6.11 on Win2003 Server
WebFOCUS 7.7.03 on Win2003 Server
Published, AdHoc, ReportCaster
Output in all variants of Excel
June 07, 2006, 10:55 AM
Amy
Thank you!! We have the problem solved by your suggestion.
June 07, 2006, 03:12 PM
susannah
you rock, DebbieJ.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID