November 27, 2006, 08:03 AM
kalyanswarnaExcel 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.
November 27, 2006, 10:02 AM
Francis MarianiPerformance 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