I have a Telerik Report and want to bind data to the report by using a stored procedure. I can accomplish that easily with a select statement or calling a stored proc that has no parameters. When I try passing a parameter I get the message "The EXEC SQL construct or statement is not supported".
I defined a report parameter called @UserID and call the stored proc like this: EXEC get_data @UserID. This appears to be inline with the sample syntax shown at the bottom of the wizard when I am creating the connection (SELECT ColumnName1, ColumnName2 FROM TableName WHERE ColumnName1 = @ParameterName). I can even call the procedure with a hard coded value and it works like so: EXEC get_data 'myparm'.
Thanks for any help
I defined a report parameter called @UserID and call the stored proc like this: EXEC get_data @UserID. This appears to be inline with the sample syntax shown at the bottom of the wizard when I am creating the connection (SELECT ColumnName1, ColumnName2 FROM TableName WHERE ColumnName1 = @ParameterName). I can even call the procedure with a hard coded value and it works like so: EXEC get_data 'myparm'.
Thanks for any help