C#
C#

help

Root Question Message

FR
FR12/23/2022
❔ SQL SERVER | SSRS | Dataset Column not Refresh When Using Stored Procedure with Parameter

so i have a Report with multiple dataset and i want to make it easy for maintenance
so i created sp that store multiple select data and access it with parameter
but when i implement it to SSRS the default column always use the first query even the param is different i try to spam the refresh button but didnt work....

any solution/alternative or did i do something wrong ? ty..

sample SP and Picture :
ALTER Procedure [dbo].[sp_reportMonthly] 
    @inputReportPart varchar(20)
as      
begin 
    IF(@inputReportPart = '1' or @inputReportPart = 'debug')
    BEGIN
      select a,b,c from table1
    END
    IF(@inputReportPart = '2' or @inputReportPart = 'debug')
    BEGIN
      select q,w,e from table2
    END
end
ContactFrequently Asked QuestionsJoin The DiscordBugs & Feature RequestsTerms & Privacy