export SSRS Adjacent groups to different excel tabs

Question

I have a ssrs Tablix, i have two adjacent groups , example group 1 : Managers and group 2 : Manager Details . they both are separate adjacent groups. client wants to export them to an excel with two tabs Managers, Details . first sheet should get all data from group 1 and second sheet should get all data from group 2.

can anyone advice.

Answer 1

1. create two additional rows in dataset with static values of xyz, abc.
2. for first group , group by xyz column and second group , group by abc column.
3. in the report make a page based on xyz, abc groups and the result is achieved automatically.