Focal Point
[SOLVED] No Query information error on Excel only, not

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

February 25, 2013, 10:30 AM
jev
[SOLVED] No Query information error on Excel only, not
SQL Report created in WebFocus 7.7.02 developer Studio.
Report displays fine in HTML and PDF, howeever, when output is changed to any version of Excel,
report returns No query informatin to decode.

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


WebFOCUS 7.6
Windows, All Outputs
February 25, 2013, 11:54 AM
Alex
I've seen that happen when the System does not allow popups. You might check your settings.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
February 25, 2013, 11:59 AM
globalwm
I recently experienced this also and the problem was with some special Stylesheet parms used in Excel format.

If you comment out all your css formatting, does it work in Excel? Also, are you performing any special formatting for excel (image/logo?)? Comment that out and see. Then you know where your issue is.

HTH


8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel
February 25, 2013, 03:23 PM
jev
popups are blocked, but site is allowed.
Commenting out all CSS formatting does not correct the problem. No special formatting- character & numeric output only.
Anything else possible?


WebFOCUS 7.6
Windows, All Outputs
February 26, 2013, 07:12 AM
MattC
Try adding your environment to your Trusted Sites in your browser settings.


WebFOCUS 8.1.05
February 26, 2013, 04:37 PM
linus
Try this and see if it resolves your issue:

Open a browser, select Internet Options/Security/Custom Level. Scroll all the way down to Scripting, make sure ‘Active Scripting is enabled’ then scroll down a little bit further to XSS Filter and make sure it’s disabled


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
March 01, 2013, 12:44 PM
jev
Tried all of these suggestions to no avail.
Finally was able to resolve issue by upgrading Internet Explorer to IE9.
Thanks to all those who offered ideas.


WebFOCUS 7.6
Windows, All Outputs