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

How to Handle a column with Length more than 8000 characters Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 7:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:45 PM
Points: 20, Visits: 138
Hi,

I have a report which consists of 40+ columns.
one of the column's length is more than 8000 characters.

Report is working fine if i remove the column with length 8000+ characters.
When ever i try to introduce the column with length 8000+ characters it is shouting at me with below mentioned Run time Error.



EventType : clr20r3 P1 : devenv.exe P2 : 9.0.30729.1 P3 : 488f2b50
P4 : system.drawing P5 : 2.0.0.0 P6 : 4f9269ff P7 : 24c P8 : 121
P9 : system.componentmodel.win32

Thanks in Advance,
Santhosh
Post #1346546
Posted Monday, August 20, 2012 12:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
Have you tried to divide this column into multiple columns ?
For Example: 10 columns each of length 800 maybe ?


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1347003
Posted Tuesday, August 21, 2012 6:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:45 PM
Points: 20, Visits: 138
Ya i tried that option also. I think Report gives huge amount of records.That is why it is giving error.
Is it may be the problem.

How many columns and rows are supported by SSRS report basically ?
Post #1347736
Posted Tuesday, August 21, 2012 7:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:45 PM
Points: 20, Visits: 138
I have 50 columns and 2000 rows for a report.It worked fine with 50 columns.

But when i tried to add 51st column which has length>8000 characters, Report preview getting failed.

Thanks in advance
Post #1347767
Posted Thursday, August 23, 2012 6:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
I think you should try to deploy your report on the report server and then run it on the server itself. if it fails there then there is a problem.

Because sometimes preview of reports which get large amount of data fail.

I don't know any alternate solution to your problem :)


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1349064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse