Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report Not Displaying 2nd Contact name Post Reply Post New Topic
Author Message
Bigced21
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Online Status: Offline
Posts: 9
Quote Bigced21 Replybullet Topic: Report Not Displaying 2nd Contact name
     Posted: 25 Nov 2009 at 8:19am
Angry
I have a renewal license report that will not display the the 2nd contact that has the same last name as the first contact that's displayed in the report. 
 
For example:
Ralph G Carpenter renewal license card will display on the report
Kenneth D Carpenter renewal license card will not display on the report
 
The report consist of 3 renewal cards per page. 
 
I have it grouped by LastName GH1 and the GH2 is grouped by ContactName. 
 
I do have 4 formulas that are using global variables instead of Local Variables to display pertinent information per renewal card license holder. 
 
Any help would be greatly appreciated, and if you need more info plz don't hesitate to ask.   
 
Thanks in adavnce
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Nov 2009 at 8:24am
Likely becasue youa re gouping on the last name.
Try making this grouping a unique field with a formula.
If you have a PK field use it (like a person # or social security)
table.lname + "totext(table.uniqueIDfield)
or use the full name
table.lname + ", " + table.fname + " " + table.midname
 
Youc an suppress the header field and just use the lanme field for dispaly but use the unique fromula field for the grouping
IP IP Logged
Bigced21
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Online Status: Offline
Posts: 9
Quote Bigced21 Replybullet Posted: 25 Nov 2009 at 10:05am
Are you saying that i should check the box in the change group options: Use a Formula as Group Sort Order.  I'm not understanding clearly by making "this grouping a unique field with a formula."  Where do i go to make it unique 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Nov 2009 at 10:10am

Make a formula field that is unique and then group on the formula field instead of the lname field.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Nov 2009 at 10:12am
Instead of grouping all of the "Carpenter" records at group level 1 it would only group all rows that had "Ralph G Carpenter".
IP IP Logged
Bigced21
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Online Status: Offline
Posts: 9
Quote Bigced21 Replybullet Posted: 25 Nov 2009 at 10:16am
You are the man!!!!!!!!  Thx!!!!!
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.