I have a doubt in SSRS.
For ex: I have 4 categories in Healthcare. Say, Kidney, ENT, Bone, Heart. All these 4 categories are stored in 4 tables.
I will run the business rules for Kidney for each month. So i will have some set of outputs for each month. Say, January - 40 records output
February - 20 records as output.
March - 15 records as output.
Altogether 40+20+15= 75 records are there in Kidney table. Like wise for rest of the 3 categories.
I have 2 report rdls.
1. Report A (Its a Summary information with count details)
2. Report B (line level information for the Report A's summary information)
I will select Jan month and Kidney from the respective drop down in SSRS report interface.
Since table name is dynamic, i used dynamic sql to get data for Report A.
From the output, i will click one column (say doctor name), that will call Report B.
Report B will produce results for this particular doctor. Here i have to get the data for that particular month (Parameter name: Month) and the particular Kidney table (Parameter Name: Category) which i selected in Report A.
Here is what, am facing the problem, i cant able to get the parameters declared in Report A(month and category parameters) to be utilized in Report B. Its showing error as Parameter expects value.
I tried these below things:
2. Created shared dataset and used that in Report B. But am getting the parameter expects value error (even i hide or make it internal in Report B).
Please help me here to overcome from this problem.