Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Changing the group name (problem) Post Reply Post New Topic
Author Message
sgallet
Newbie
Newbie


Joined: 01 Aug 2007
Online Status: Offline
Posts: 2
Quote sgallet Replybullet Topic: Changing the group name (problem)
    Posted: 01 Aug 2007 at 10:28am
I have a report using 2 tables: accounts and users
Accounts are related to users (who create them), I need a list of accounts grouped by the users who created them. 
 
I can group the accounts by the 'CreatedBy' field in the accounts table, but that's a long ID# which is useless to me (I don't know who that refers to...). 
If I try to change the group name by selecting the new group name field to be the 'Full Name' field in the User table, the report shows nothing..... ?????????  Angry
 
Can I only change the group name to a field in the same table, or do I have to link the fields in the database expert?????
 
Any ideas?
 
 
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 01 Aug 2007 at 2:02pm
I'm confused when you ask if you have to link the fields in the database expert. Do you have two unlinked tables?

Nonetheless, yes the two tables must be joined in the Database Expert. If the report works when you group on ID, then I would leave that as the group field, but then display the FullName field in the group header. That way the report groups correctly and you see data that makes sense.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 01 Aug 2007 at 2:51pm
If you need to sort by the name (sorting by ID probably won't make sense to most users....), you'll have to link from the CreatedBy field to the correspoinding field in the User table.  Then you should be able to group by the user name and still have your data.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
sgallet
Newbie
Newbie


Joined: 01 Aug 2007
Online Status: Offline
Posts: 2
Quote sgallet Replybullet Posted: 02 Aug 2007 at 9:46am
Thank you!!!!!  The default link was from systemID to SystemID, I needed CreatedBy to SystemID, changed that, and then changed the Group Name to display by FullName and it WORKS! 
thank you again Clap i'm just learning this.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Aug 2007 at 12:14pm
As I like to say, SmartLinking isn't smart.  I ALWAYS turn it off and set up my own links between tables.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.