Post reply

How to Handle a column with Length more than 8000 characters

  • August 17, 2012 at 7:45 am

    #262954

    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

  • August 20, 2012 at 12:06 am

    #1527443

    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

  • August 21, 2012 at 6:05 am

    #1528074

    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 ?

  • August 21, 2012 at 7:09 am

    #1528100

    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

  • August 23, 2012 at 6:36 am

    #1529212

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply