I have data eg.
ID Gender Age
567 Male 78
567 female 34
345 Female 45
345 male 67
564 Male 78
Its Giving me TOTAL=3 Columns
I have used GROUP BY ID. Now When I inserted a BOX in detail section & In that BOX I dragged Gender & male columns. It gives me 5 columns.(Like repeating ID=567 twice for Male 78 & Female 34)Now I'm having 5 boxes in Detail Section.
Is there any way I can have only 3 Boxes In Detail Section
showing Male,Female in one box per ID?
ID Gender Age
567 Male 78
567 female 34
345 Female 45
345 male 67
564 Male 78
Its Giving me TOTAL=3 Columns
I have used GROUP BY ID. Now When I inserted a BOX in detail section & In that BOX I dragged Gender & male columns. It gives me 5 columns.(Like repeating ID=567 twice for Male 78 & Female 34)Now I'm having 5 boxes in Detail Section.
Is there any way I can have only 3 Boxes In Detail Section
showing Male,Female in one box per ID?