I have a requirement to show the data at 3 different levels with multiple sections(in different tablix controls/tables)
1--> at Report level: This section(s) contains data common at the report level
2--> Group 1 level: some sections common to this Group level
3--> Group 1->Group 2(Child group of Group 1): Some sections common to this level.
currently, i am calling subreport from parent report.
In parent report showing Report level sections, then i placed 1 tablix with 2 groups (Group1--> Group2)
In Group 2 i am calling sub Report by passing Group 1 value and Group 2 value.
In Sub Report I need to show something like below.
... (Common to Group1 level)
... (Common to Group1 and Group 2 level)
each section will have different datasets with diff. sps.
now my query is how can i show this type of data in sub report/ Parent Report?
Please guide me.