April 12, 2013 at 11:17 pm
Dear Friends,
I have designed a report in SSRS Visual Studio-
but when i try to render it in Visual Studio or pload it on SSRS web get the following error-
"The value of the Width property for the report ‘body’ is “466.61111in”, which is out of range. It must be between 0in and 455in. (rsOutOfRangeSize)"
any help will be appreciated please on this.
Thanks
Dhananjay
April 13, 2013 at 6:35 pm
I would suggest that you click on the body of the report, then open the Properties window, find the "Width" property and change the value to something between 0in and 455in.:-)
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);March 16, 2015 at 3:56 am
Not an overly useful comment!
I have a very similar issue but to do with the Height of the report. Again SSRS generates an error stating 'height must be between 0in and 455in' I am trying to produce a report of 1021inches.
How can I get SSRS to produce such a big report?
March 16, 2015 at 5:34 am
adam.lawrence (3/16/2015)
Not an overly useful comment!I have a very similar issue but to do with the Height of the report. Again SSRS generates an error stating 'height must be between 0in and 455in' I am trying to produce a report of 1021inches.
How can I get SSRS to produce such a big report?
To be honest, it wasn't the greatest question. :hehe:
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);March 16, 2015 at 9:19 am
To be honest, it wasn't the greatest question. :hehe:
There is a genuine issue here though and that is that SSRS seems to have an arbitrary limit on the width and length of a report.
For the length is seems to relate to about 45 pages.
This limit I find hard to appreciate as heavy SQL users will want to use SSRS to produce the mother of all reports.
So, in simple terms, how can we exceed the '455 inch' limit when designing a report?
I'll give you a clue, it's not a property....
May 14, 2015 at 5:07 pm
adam.lawrence (3/16/2015)
Not an overly useful comment!I have a very similar issue but to do with the Height of the report. Again SSRS generates an error stating 'height must be between 0in and 455in' I am trying to produce a report of 1021inches.
How can I get SSRS to produce such a big report?
I signed up on this forum just to say, "Come on, man!"
His comment actually helped me solve my problem. I read his comment, facepalmed and proceeded to delete a bunch of stuff and make the report come in under 466 inches. I know it seems obvious, but the error message just didn't hit me right.
Anyway, go read this: http://www.catb.org/esr/faqs/smart-questions.html
and note that: SSCommitted > Forum Newbie
and that: nice, helpful people > critical, entitled a-holes
May 15, 2015 at 5:12 am
I signed up on this forum just to say, "Come on, man!"
His comment actually helped me solve my problem. I read his comment, facepalmed and proceeded to delete a bunch of stuff and make the report come in under 466 inches. I know it seems obvious, but the error message just didn't hit me right.
Anyway, go read this: http://www.catb.org/esr/faqs/smart-questions.html
and note that: SSCommitted > Forum Newbie
and that: nice, helpful people > critical, entitled a-holes
Thank you for you very interesting and enlightening reply.
Yes, I could reduce the size of my report design but that would mean, as you did, I would need delete stuff from my report. However, everything in the report is what is required by the business to be there. Its an activity report so I want all the info on one report not seperated into mutiple reports (before you suggest splitting my mahoosive report).
I do have a lot of images in the report so I don't know if these can be reference rather than embedded.
and note that SSCommitted != "I know everything coz I've had a zillion posts". Quantity is not a measure of quality.
and that: I wasn't being critical, I was pointing out that the question hadn't been fully answered (IMHO). However, you seem to have fallen foul of you own catigorisation in your reply. Cangratulations. Very ironic.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply