Skip to Content
author's profile photo Former Member
Former Member

Report with subreport is slow to save in the CR Designer within VS 2010

I have a Visual Studio 2010 VB.NET application that includes embedded .rpt files. One of the rpt files includes several subreports. Saving the main report in Visual Studio takes about 100 seconds. After several hours of analysis and trying the suggestions found at this forum (make sure the Verify on Every Print is unchecked, Page Setup No Printer is checked, update to 13.0.5, etc.) I've not been able to resolve the problem.

The delay seems to be related to a large number of parameters in the main report's stored procedure AND the main report includes at least one subreport. I've re-created the above with a simplified report and stored procedure that includes a single subreport. The main report displays the current date, page number and the embedded subreport. The subreport is blank and does not accept parameters. The main stored procedure includes ~135 parameters (none of which are actually used in the sp). With this scenario, save operations of the main report in visual studio take 100 seconds. If I reduce the number of parameters to ~105, save operations take about 50 seconds. If I reduce the number of parameters to ~75, save operations take about 20 seconds. If I reduce the number of parameters to ~45, save operations take about 7 seconds.

If I remove the subreport from the main report, the main report saves in less than 2 seconds (stored procedure has ~135 parameters).

If I reduce the number of parameters (~15) in the stored procedure and include the subreport, the main reports saves in ~2 seconds.

At runtime the report encounters a similar delay. In the debugger the entire delay occurs on the setting of the first parameter value (ReportClass.SetParameterValue). The first parameter is an integer. There is no delay when setting the other 134 parameters (integers, varchars and datetimes).

Any suggestions?

Regards

Kevin

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 07, 2013 at 08:39 PM

    Hi Kevin,

    Turn on the DB Logging, may show you what is happening.

    Try loading a dummy report first, it takes time for your app to load the CR runtime. Common work around and known.

    What happens if you load the report again, same delay?

    Don

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Kevin,

      Thanks for doing all of that debugging. It does appear to be a Cr issue. Unfortunately I don't have time right now to test this.

      If you want to purchase a single case a rep can duplicate it and I'll likely end up getting it anyways.

      Wait a bit, SP 6 is coming out soon and see if that resolves the issue.

      I'll see if Ludek has time to test this...

      Thanks

      Don

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.