Post reply

SSRS 2008 - Report Not Loading in IE

  • June 25, 2015 at 2:45 am

    #298175

    Hi All

    I have a report that is not loading in IE and sometimes taking more than 10mins to display.

    The report query completes in 3 seconds and returns around 90 000 rows.

    I've investigated the ExecutionLog2 table in ReportServer db and can see the data size is around 117MB (I get this from the bytecount field).

    I've created another report to display 90 000 rows and that works fine. The size is 0.016MB.

    I'm thinking that the size of the report is the issue...but not able to fine any definite information on this.

    Thanks for any and all Reponses.

    Denesh

  • June 25, 2015 at 2:52 pm

    #1808244

    What is the report doing? A lot of graphs? Any images on the report? How long does the report take to run in Visual Studio/Report Builder?

    Joie Andrew
    "Since 1982"

  • June 25, 2015 at 9:49 pm

    #1808308

    Hi

    No graphs or images just tabular data.

    I've not tested it in report builder...

    Was told to test latest sp...getting that installed

  • July 9, 2015 at 7:22 am

    #1811299

    hi

    Is your table inside a rectangle ?

    Did you set the property KeepTogether to True ?

    If so then try to put it False on all data region

    This will permit the pagination of the report

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • July 9, 2015 at 9:54 am

    #1811365

    Did that help.

    If multiple tablix try checking the datasource option : SUse Single transaction when processing the queries.

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

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