July 25, 2007 at 4:55 am
Hi,
I have a problem with a report in SSRS 2005. I tried to add some custom code to a report.
The code is absolutely simple and correct.
But when trying to show the report the debugger shows the following error message:
error [BC30494] Line is too long.
When I remove the code the report works again.
The code is about 12 words and could not be the problem.
Could anyone help please?
Best regards,
Stefan
SK
May 5, 2009 at 8:58 am
Hi,
This has to do with the table regions in your report rdl.
SSRS in the backend converts all table regions to a vb code.
this generated vb code has a size limitation of 64k.
It occurs when you have wide table regions.
which actually contain n*m textboxes and which have to get converted to vb code as textboxes.
There can be two ways to try and remove this error:
either reduce the no of columns in the wide table.
if business demands the columns, then we could try to split the tables into two and make it look like one.
Since the vb code generated is per table region, this reduces the size of each vb code per table.
Another simpler thing to try before splitting the tables,
is to try and renaming all textboxes, controls in the table to a smaller name.
try something like t1, t2, t3 ...
this would also reduce the size of the vb code to some extent
January 8, 2014 at 4:02 pm
Hi there.
Is this just an issue with SSRS 2005? We are getting ready to upgrade and we are having this issue in a few of our reports. I just wonder if I need to break apart the tables, or will this not be an issue in SQL Server Reporting Services 2008R2?
Thank you.
P
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply