2 Replies Latest reply: Feb 6, 2014 4:46 PM by Don Williams RSS

CR for VS (13_0_5) - reports sometimes very slow to load on Windows 7

Susan Gillingham
Currently Being Moderated

Hello

 

We have a windows forms app that uses CR for VS (13_0_5). A client has recently upgraded their PCs from ancient XP ones where their reports ran perfectly to reasonably spec'd Windows 7 ones where every few minutes a report that normally opens in seconds will take ages to load - anywhere from 2 to 5 minutes.

 

Each user is running the same report over and over again e.g. an invoice or a purchase order. Very roughly, three times out of five it will load in seconds, the other twice it will take minutes (even if they use the same parameter values)

 

We have not seen this issue at any other site and have been unable to find a cause.or a solution by other means (google et al.) and so wondered if anyone here had come across anything similar

 

Thanks

Susan Gillingham

  • Re: CR for VS (13_0_5) - reports sometimes very slow to load on Windows 7
    Ludek Uher
    Currently Being Moderated

    Hello Susan

     

    Updating the install to SP 8 will not be a bad idea. There are always performance improvements from SP to SP.

     

    One thing I wonder about; is it the same report(s) running slowly, or would the same report run fast one time and slowly the next time?

     

    Perhaps a bit of logging may also help. Process Monitor is a great utility for that. Logging in your own app to see where the slow downs occur may also be an idea (e.g.; is the slow down occurring on report load, db connection, printing, exporting, parameter passing, etc.).

     

    Other ideas;

     

    Look at the printers. If a report is set to use a specific printer and the printer is not there, the report may take time looking for it, eventually substituting the default printer.

     

    Database connectivity:

     

    For OLE DB then use:

     

    MS SQL 2005 - OLE DB Provider

    MS SQL 2008 - SQL Native 10

    MS SQL 2013 - SQL Native 11

     

     

     

    For ODBC then use:

     

    MS SQL 2005 - SQL Native

    MS SQL 2008 - SQL Native 10

    MS SQL 2013 - SQL Native 11

     

    Also, see if using the search string 'crystal net performance' or 'crystal net slow', etc. will help. Search box is in the top right corner of this web page.

     

     

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

  • Re: CR for VS (13_0_5) - reports sometimes very slow to load on Windows 7
    Don Williams
    Currently Being Moderated

    Hi Susan,

     

    And to backup Ludek's suggested update, there was a known issue introduced in SP 5 and that is if the report has a lot of Parameters it can take a long time simply load the report.

     

    It was fixed in SP 8.

     

    Thank you

    Don

Actions