Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with box in detai section

Status
Not open for further replies.

nikol

Programmer
Apr 12, 2005
126
US
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?
 
You gave an examle of your data, give an example of your desired output and tables. This would help.
MrBill
 
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
 
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
 
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..
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top