I have a stored Procedure that takes in 3 parameters -
Exec dbo.usp_ActualFTE @Year, @Scenario, @Quarter
This stored procedure has 2 columns that are constant and the remaining columns change during run-time depending upon the value of the Quarter Parameter. For example, if Quarter parameter is 1, then the columns displayed are:
ProgramName , ProgramNum , Actual_Jan , Actual_Feb ,Actual_Mar , LBE_Jan , LBE_Feb , LBE_Mar
If the Quarter Parameter is 2, then the columns are:
ProgramName, ProgramNum, Actual_April,Actual_May,Actual_Jun,LBE_April, LBE_May,LBE_Jun
I want to create this report in SQL Reporting Services and I am not sure how to do for the fields. The dataset is not displaying any fields if configured to pull up the stored procedure. Please let me know how to create a SSRS report with dynamic SQL columns.