Focal Point
Excel Tabs

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

November 27, 2006, 08:03 AM
kalyanswarna
Excel Tabs
Hi All,

i am merging 3 reports in to one FEX file, output for this file is three reports as differenet tabs in excel, i got the solution but here the problem is it's taking too much time to run this report.
how should i improve the performance of my report.

i have four parameters in this report.


Thanks,
Kalyan.S
------------------------------------
WebFOCUS 7.1.4, Win XP SP2,
Oracle8i.
------------------------------------
November 27, 2006, 10:02 AM
Francis Mariani
Performance has nothing to do with the number of parameters in the report and everything to do with the efficiency of the SQL code generated by WebFOCUS.

If you're accessing relational tables with WebFOCUS, turn on SQL tracing and change JOINs. BY statements...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server