Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error [BC30494] Line is too long Expand / Collapse
Author
Message
Posted Wednesday, July 25, 2007 4:55 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 6, 2011 7:52 AM
Points: 80, Visits: 44

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




Kindest Regards,

SK
Post #384980
Posted Tuesday, May 5, 2009 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 8:46 AM
Points: 1, Visits: 4
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
Post #710325
Posted Wednesday, January 8, 2014 4:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 3:59 PM
Points: 1, Visits: 0
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
Post #1529136
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse