COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: lorenmario on 29 Jul 2013 08:45:13 AM

Title: Slow because of the Page Break - Help me!!
Post by: lorenmario on 29 Jul 2013 08:45:13 AM
Hello good day!
I have a question here in a Report Studio, the report it was done with a database SQL server, and was running normally, on average took 10 minutes to run.

I need to make a page break per Store, because after it is exported to Excel every store should appear in a tab. The problem is when I add a page break in the report takes hours to run, even when I select only 2 stores in the prompt.

Does anybody know why this happens?
Is there any alternative??

Thank you!
:o