I'm using telerik reports with stored procedures and after upgrading to Q2 2012 I receive errors in the report viewer when trying to preview reports using sp's. I also have quite a few reports using dataset which runs fine still.
I use string as input parameter type and convert to uniqueidentifier inside the sp using the CAST function. This worked like a charm in my previous install (Q2 2008), but trying to run the same reports now gives the following error:
An error has occured while processing Report 'some_report_name':
Conversion failed when converting from a character string to uniqueidentifier
When debugging the sp and copying the same value as I use as default value in the report parameter dialog into the input parameter value field, the sp runs fine. So it looks to me like the value of this param gets invalidated somehow between the report viewer initiation and the execution of the sp. Any ideas ?
TIB
I use string as input parameter type and convert to uniqueidentifier inside the sp using the CAST function. This worked like a charm in my previous install (Q2 2008), but trying to run the same reports now gives the following error:
An error has occured while processing Report 'some_report_name':
Conversion failed when converting from a character string to uniqueidentifier
When debugging the sp and copying the same value as I use as default value in the report parameter dialog into the input parameter value field, the sp runs fine. So it looks to me like the value of this param gets invalidated somehow between the report viewer initiation and the execution of the sp. Any ideas ?
TIB
1 Answer, 1 is accepted
0
Tor Ivar
Top achievements
Rank 1
Rank 1
answered on 09 Aug 2013, 07:23 AM
This is np longer an issue. I have overlooked something unrelated to what I asked in the post.