Problem with box in detai section

[nikol]

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?

 

[MrBillSC]

You gave an examle of your data, give an example of your desired output and tables. This would help.
MrBill

 

[nikol]

I have a table with Parent-child relationship.
ID= parent_id
Gender=Child Gender
Age=Child's Age
cuid=Child's ID
My table looks like as:
ID CUID Gender Age
12 8 Male 4
12 9 Female 7

14 6 Male 9
14 8 male 4

Now,I have 2 clients who have 2-2 kids with their gender & Age.
I want to show only 2 records GROUP BY ID in a BOX.
Like:
(12 Male 4
Female 7 )in 1 box
(14 Male 9
Male 4) In 2nd box.

But When I insert a box on gender & age columns in detail section, I'm getting 4 boxes for each child.
In short I want only 2 boxes per ID but I'm getting 4 boxes per cuid.

I hope this will help u to solve my problem

 

[MrBillSC]

By "box" do you mean a single text field with a boarder around it? Also, your example displays one child below the other for a parent_id. Is that what you want or do you want the children on one line with the parent?
MrBill

 

[nikol]

Yes, Box is kind of text field. You'll see that in INSERT Menu. I want boxes per parent_id. If there r 2 parent_ids I want 2 boxes which will contain no. of children in it. but I 'm getting (Parent_ids* no. of children)boxes.
Like:
ID 12 has two children. I want only 1 box for that ID which will display both children's gender & age in both columns Then I will get only 1 Record. I'm getting this without box but when I insert a box in detail section & drag ID,Children's(Gender & age) columns in that box & then refresh the report. It gives me 2 records
one for CUID 8 & other for CUID 9..

So,I want all children in 1 box per parent_id..

 

[lbass]

Text boxes are limited to one section. Instead of using a text box, go to design mode and insert a box object that includes your group header, detail, and group footer section. You will have to experiment a little to get this right. It will help if you magnify the view to 200% or so.

-LB