Sunday November 19th 2017

Categories

Insider

Archives

Linking a sub report based on procedure – stored procedure parameters cannot be Linked

ASP.net Web Parts
I came across this question several time on linking stored procedure parameters to main report. Problem arises when we select stored procedure as a table or view from the data source. It can be resolved by calling a stored procedure from command window – “DatabaseName”.”dbo”.”StoredProcedureName”{?StartDate}, {?EndDate} and creating parameters in command window.