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!

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

Keep Objects together

Status
Not open for further replies.
kyzina

kyzina

Technical User
Mar 10, 2009
38
US
I have multiple column report and I would like to keep the objects together, but I am getting either title or phone number for the person on the second column.

This is what I'd like to see:

GH1 DeptName
GH2a @NAME
GH2b Title
D PHONE

This is what I have it now:

GH 1 DeptName Title
GH 2a @NAME PHONE

or

Any suggestions?

 
Sort by date Sort by votes
Check your section expert. I believe that there is a check in the "underlay following sections" box.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
Upvote 0 Downvote
Thank you for the reply. But it's not working. Any sugestion?
 
Upvote 0 Downvote
The problem is in the section expert. Make sure that none of the GH1 sections are marked with "underlay following sections" and that none are indicated with multiple records.

Are you sure you want the data in a group header and not the details section?

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
Upvote 0 Downvote
Hello,

When I put everyhtin to the Detail section the gop names repeating with every name. And just need to show one time the dept name and then all people with that department.
May be I am doing something wrong?

Thank you
 
Upvote 0 Downvote
You are correct to put the group names in the group header section. I assume that each person can have more than one phone number and that is why you put the phone in the details section.

Please check the section expert for GH1. Make sure that "underlay following sections" is not checked. Your example indicates that it is.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
Upvote 0 Downvote
I checked and "underlay following sections" is not checked.
Yoa are correct about that one person can have more than one phone number. Any more ideas? Thank you for yout replies.
 
Upvote 0 Downvote
Actually I am stumped. I would have to see your report to help further.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
472
john432
john432
capronton
  • Locked
  • Question
Need to keep the first record and filter out other duplicate row
Replies
2
Views
115
capronton
capronton
adnil
  • Locked
  • Question
Combining fields together
Replies
2
Views
75
adnil
adnil
PhilB2
  • Locked
  • Question
Keeping a set of 3 groups together
Replies
0
Views
55
PhilB2
PhilB2
capronton
  • Locked
  • Question
Keep first and last record for each bus and suppres all other records for each bus 2
Replies
3
Views
114
capronton
capronton

Part and Inventory Search

Sponsor

Back
Top