Report Performance

[srinu_anu2007]

Hi Experts,

How to improve report performance of developed report? how many ways we can do? please let me know.

Thanks,

[MFGF]

Hi Experts,

How to improve report performance of developed report? how many ways we can do? please let me know.

Thanks,

Hi,

The absolute best way to improve the report performance of a developed report is to make it go faster. There are probably a number of ways to do this - likely more than one and less than a lot. :)

Hope that helps!

MF.

PS. From a question as devoid of detail as yours, that's really the only answer that can be given - one which is equally as devoid of detail. We will do our best to help, but you will need to tell us what type of report it is, what the queries and objects are doing, what complex calculations you might have, what conditional rendering is going on, what the underlying data source is, what kind of package you are using, how much data your report is spanning, what page breaks you are doing, what master/detail relationships you have etc etc.

[blom0344]

Upgrade the hardware! But, then everything will  be faster  ;)   

[CognosPaul]

On a somewhat similar note, I've found that truncating all of the tables also tends to improve the performance of most reports.

[cognostechie]

You can also put the data in EXCEL instead of a database. Make sure to put all of the data in one EXCEL spreadsheet and the no. of rows should not be more than 100. That way the report will be a lot faster and for the rest of the data you can run the report multiple times and keep changing the data in that EXCEL file as many times as you run the report. 

[bvk.cognoise]

Hi srinu,

This is a broad question.actually report performence depends on lot of things mainly the way your developing  the report.
hope below links could help you some what.....below links give you a few genearl tips to tune you report not completely

http://pic.dhe.ibm.com/infocenter/cx/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.0.doc%2Fc_rs_report_slow.html

http://www.cognoise.com/index.php?topic=13815.0

http://it.toolbox.com/wiki/index.php/Cognos_Performance


Regards
bvk