Thursday February 22nd 2018




Linking a sub report based on procedure – stored procedure parameters cannot be Linked 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.