Post reply

Cannot create a row size of 8164 whiuch is greater than allowable size 8060 while creating report in ssrs.

  • October 4, 2010 at 8:26 am

    #229972

    Hi,

    I am creating new report in SSRS 2005. I am using multi select drop down in the report.

    When I select all values in the drop down (drop dwon consists of nearly more than 300 values), and click on view report, I am getting below eror message.

    "Cannot create a row size of 8164 whiuch is greater than allowable size 8060"

    I have checked this from backend. There is no problem. Is there is any way to increase the multiselect variable width.

    Appreaciate your help on this.

    Thanks

    Manohar

  • October 5, 2010 at 9:19 am

    #1231820

    I'd imagine this is actually an error form the source database not from SSRS, but I could be wrong... Have you tried to execute the same query directly from SSMS? Do you receive the same error? You may be sorting your output in some form or other which may be creating a worktable in tempdb. As the rows are inserted into this worktable one is 8164 Bytes in length. You cannot create a row that is longer than the length of a page or 8KB. Have a look at your output, make certain you are only bringing back what you need.

    -Luke.

    Edit: change 8164 KB to Bytes. Wasn't paying attention the first time.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 5, 2010 at 1:02 pm

    #1232007

    hi,

    just for a try use expression as in your report or Query which will be easiy to u,somethin like it will take 8000 positions ("Left(Feildvalue,8000)" if it works then we can say its a report issue with >8060.

    Thanks

    Veeren.

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

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

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