When I run the SSRS report with data having 150 000 characters it gives error
HResult E_FAIL has been returned from a call to a COM Component
I am using the single textbox to display this data. For any other data it works fine. I have searched on some other forums and they say that you can only print 32 000 characters using SSRS textbox in 2008, but then why its working for some other data with 150 000 characters and not working with this particular data.
The data is having numbers as below
1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890121234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890 1234567890
For normal data its working fine. The data type of the SQL server column is nvarchar(max) and it has such numbers only for 150 000 as the data.
Sometimes it returns the result as value does not fall within the expected range, but this a text column so why it is then considering this as number. The other data example is having a 100000 characters as strings and then rest of 50000 characters as numbers that are separated with spaces as given above for example 1234567890 1234567890 like this upto 50000 characters length.
I am not sure how to deal with this error.
Advertisement
Answer
We have not found solution to the Technical error, but after discussing this with Onsite folks, we have come to conclusion that the data is in single line, if line breaks are inserted in the data, then SSRS is working fine. SO we have proposed a Data Fix for this issue rather than going on and on with technical error of SSRS. We have not done any changes in SSRS. If line breaks are inserted in data then it works fine.