I have 2 dataset as HDR and DTL.
1) DTL, Query which populate detailed data and group on region.
2) HDR, StoredProc which runs based on region (param) and default is 'N'.
How to pass the param value in HDR (SP), based on group change to get the respective details.
All the details must populate in the same tablix structure (SSRS-2008R2).
The output template looks like:
*************************
--------------------
Region: North HDR : exec SP @reg
Contract: Temp
date: 04/05/2015
---------------------
DTL: Select * from empMaster group by Region
Empid EmpName Dept Region
01 aa HR North
02 bb Ops North
---------------------
--------------------
Region: South
Contract: Daily
date: 04/06/2015
---------------------
Empid EmpName Dept Region
03 cc Fin South
04 dd IT South
***************************************
Please someone help on this to implement.