Post reply

ssrs render time

  • October 9, 2012 at 7:29 am

    #393342

    hi

    i have this proc which runs in 8 seconds in management studio but just hangs in BIDS.

    i'm fairly new to ssrs so am i missing something to make it run?

    EXEC [dbo].[usp_SAM_report_SSRS] @YEAR, @MONTH, @DIV, @FOC

    Thanks

  • October 9, 2012 at 8:11 am

    #1547232

    if i drop the report entirely and recreate from scratch. It runs the first time then when i try to run again it just hangs?

  • October 9, 2012 at 11:00 am

    #1547297

    The hanging in visual studio can be caused by a couple different things.

    I've had it hang simply due to the report having to evaluate alot of rows.

    and or alot of rows in combination with one or more groupings in the report.

    Not sure what issue your having tho.

Viewing 3 posts - 1 through 3 (of 3 total)

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