I hope, I raising my problem in correct forum.
I am getting error when I execute report and giving parameters to Store procedure. when I select value form enumerate list and sending parameter as select value ID its send numeric ID value in round bracket that's why its not able to run store procedure.
[b]12:42:49 Error in model 'VarianceModel': Unexpected error when executing the following SQL statement: EXEC [dbo].[VarianceReportByEmployee] '2022-01-01 00:00:00','2022-01-01 00:00:00',(2)
Error detail: Incorrect syntax near '('
Parameters of model Start Date, End Date and Entity ID
If anybody have any solution please reply.
Thanks For your Support.