perfomance

[rambabu]

Hi to all

how can we increase the performance in Report Net ReportStudio?

please help me out in this.

Thanks in Advance

[Venkatesh S]

Hi,
you want to increase the performance of the reports?

[rambabu]

thanks for replay

yes, i want to increase the performance of the reports.

i know that by applying filters and prompts we can increase the performance.

is there any another ways to increase the performance?

thanks in advance

[MFGF]

Hi,

Just another couple of tips:

Keep the report (and the query) as lean as possible - ie don't bring in items that are not required.
Try to keep the number of items you group and/or sort on to a minimum - ie use 'level span' where appropriate rather than grouping on a second column having a 1:1 relationship with an existing grouped column.
Try to keep the number of query calculations to a minimum, and particularly try to avoid using functions/summaries that you know may give poor performance.

Regards,

MF.

[raj_tumati]

hi,
   by applying filters and prompts to increase the performance.

[raj4cognos]

hi,
   by applying security filters to increase the performance.