String or Binary Information would be truncated
I have a report I am trying to pass paramaters in for a report.
the report points tro a stored procedure and when I pass in the same paramater in the stored proc with management studio it renders fine.
I have rebuilt the report body , the datasource and the datasets...
I keep getting the error mentioned - any ideas?
KDW
April 13th, 2011 11:53pm
Please verify the below things:
1. Check your store proc parameter datatype and Report parameter datatype
2. Check if report parameter is multi select, then need to handle multi-select parameters in report and SP
Please let me know if it resolves.
---Senthil
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 2:08am
I thing you need to change the length of your field.
keep it MaX and try
Dasari
April 14th, 2011 2:58am
Not Max - but something ResonableKDW
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 11:25am