Passing Parameters in RDLC causing problems.

Question

User-1042970710 posted

I am using MS ReportViewer with RDLC File in my .ASPX page I have already defiend Parameter @ReportType. I already check Allow Empty, Allow Null in the parameters settings.

The ReportViewer Control name is rvTotalBooksByReceiver

Now I pass parameters using the following Code.

(Actually I pass a hidden field value to the parameter "ReportType")

 

rvTotalBooksByReceiver.LocalReport.SetParameters(New ReportParameter("ReportType", hvFixedText.Value)) 

 rvTotalBooksByReceiver.LocalReport.Refresh()

 

But the following Error occurred.

"
An error has occurred during report processing.
Input string was not in a correct format "

The Hidden value contains plane UNICODE Arabic text. It doesn't even work if I hard code the value!!

-----------
It looks strange to me becuase the same code works fine in my other pages can any one help?

 

Answer 1

User-8475372 posted

The error "Input string was not in a correct format" will occur mostly with the DataType of the object/field.

1. Check for the datatype of the field.

2. Check of the length of that datatype field (try increasing the length of the data field in sql)