ReportServer Forum

michigunesh

Member

Registered: 2018-12-20

Using Stored Procedure in Dynamic List

I have to create Dynamic list where data source is stored procedure. I tried to execute stored procedure but it is not accepting. Could you please advice if I can use stored procedure or I have to srictly use SQL only. Is there any specific format I need to use. Ised below few syntaxes. Nothing worked

execute dbo.RPT_Stored Procedure '2022-08-01', '2022-08-20'
execute dbo.RPT_Stored Procedure ('2022-08-01', '2022-08-20')
dbo.RPT_Stored Procedure ( '2022-08-01', '2022-08-20')
dbo.RPT_Stored Procedure '2022-08-01', '2022-08-20'

Tobias F

Administrator

Registered: 2020-02-07

Re: Using Stored Procedure in Dynamic List

Hi michigunesh,

for stored procedures information, please take a look here:
https://forum.reportserver.net/viewtopi … d=461#p461

Regards,
Tobias