I have created many BASIC reports in SSRS with Stored Procedures. I have never created a report with multiple filters from drop down lists. I need to be able to select one or more in the list.
I am very versed in SQL but light on complex stored procedures. I will try to provide as much information as I can.
Drop downs need to be set up like a filter on a pivot table. SEE ATTACHED. The goal is to REPLICATE the SSRS Report to look like the filters used in the PIVOT. I need Help with this.
My stored procedure:
ALTER PROCEDURE [dbo].[PROC_CR_ARCA_No_Doc
@qry_result char(30) <<What do I put here to indicate a list?>>
@pgm_nm char (30)
SELECT * FROM [corporate_reporting].dbo.
WHERE qry_result = (@qry_result)
AND pgm_nm IN = pgm_nm
AND pgm_stg_nm = @pgm_stg_nm
AND special_campaign = @special_campaign
AND Portfolio = @Portfolio