SQL Server Performance

SSRS Report load through URL Performance problem

Discussion in 'SQL Server 2005 Reporting Services' started by Ismailc, Sep 3, 2009.

  1. Ismailc New Member

    Good day, I need help.
    In VS2005 SSRS when preview the report it runs for 2 seconds and then I deploy.
    But I call the report's URL from a web page on load event.
    The web page without the report opens as normal quickly but with call the SSRS report it takes 20 seconds to open & run.
    Is there something i can do or missing, a property to speed report load or run?
    Please Assist
  2. FrankKalis Moderator

    Have you found a solution or workaround to this issue in the meantime?
  3. Ismailc New Member

    No, but it's fine.
  4. FrankKalis Moderator

    Thanks for feedback!
  5. Madhivanan Moderator

    [quote user="Ismailc"]
    No, but it's fine.
    There is always time difference when the report is viewed in working environment and via exe/web page
    Make sure you applied enough filters to get only data that are needed

Share This Page