I have a result set like below.
ID Name DOB Gender Address Switch
1 ABC 1/1/2001 Male 39th st, Elwood, NY Incident
2 ABC 1/1/2001 Male 89 Howard Cross, NC Current
3 ABC 1/1/2001 Male West Pokland Dr, TX Default
2 DEF 5/21/2006 Female Apt 4, Riggs St, WV Current
3 IJK 6/8/2009 Male 10 Morning Side Avenue, VA Default
I want to show the grid for ID, Name,DOB as a grid on top of the report, followed by a group on the name, which will display the details of the person, which will have all the details, including another grid for different addresses a person is involded with.
Please advise as to how to do this.