Report is taking long time to run on report manager.

  • Hello,

    One report is running fine in BIDS and taking some seconds in BIDS. BUT it is taking very long time on report manager and failing. Can you tell me what is the reason? OR how to fix this.

    Thank you,

    BMR

  • Is there any particular message you get when it fails? May be stupid question but does the hosted server has enough capacity to handle reports?

  • Take a look through the trace files for more information.

  • Just out of experience: Are you running the reports against the same database/cube, with the exact same parameters? It is easy to overlook some slight differences in the parameters, which can drastically change the performance.



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • Thanks for reply. It is a database issue.

  • Hi,

    May i know that database issue.....i am also facing the same issue not able to view report in report manager..

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply