Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to Handle a column with Length more than 8000 characters


How to Handle a column with Length more than 8000 characters

Author
Message
Santhosh Yamsani
Santhosh Yamsani
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 163
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
H4K
H4K
SSC-Enthusiastic
SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)

Group: General Forum Members
Points: 135 Visits: 567
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
Santhosh Yamsani
Santhosh Yamsani
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 163
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 ?
Santhosh Yamsani
Santhosh Yamsani
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 163
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
H4K
H4K
SSC-Enthusiastic
SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)SSC-Enthusiastic (135 reputation)

Group: General Forum Members
Points: 135 Visits: 567
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 Smile

BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search