Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formula help Post Reply Post New Topic
Author Message
Angel
Newbie
Newbie
Avatar

Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 4
Quote Angel Replybullet Topic: Formula help
    Posted: 20 Aug 2008 at 1:06pm
I'm new to Crystal Reports so I'm hoping someone can help me.  I'm trying to create a report that includes fields which have fixed values. 

Ex. labeled "WNN" comes across as _785OLFZW2 in Crystal

There will be several of these fields in the report so I'm trying to create a formula that will allow me to show the assigned value as opposed to given value...

I hope this makes sense and any help would be greatly appreciated!!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Aug 2008 at 1:48pm

Hi Angel,

Unfortunately, I'm confused by what you are asking. How does "WNN" come out as _785....? Is the data screwed up or is this data in a related field?
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
Angel
Newbie
Newbie
Avatar

Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 4
Quote Angel Replybullet Posted: 20 Aug 2008 at 1:53pm
Sorry, I'll try and be more clear.  The fields are drop down menus already set in the program I'm using.  We have changed the names in the drop down to fit our purposes.  When I pull those fields over it shows values such as _785OLFKO5 instead of the name we have assigned.  Here are some more examples:

Shows up as:   I need it to say:

_785OLGYOL    Networking
_785OLFIWS    Other
_785OLGEDM   Print Ad

Does this make sense?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Aug 2008 at 5:43pm
Yes, that makes more sense. Thanks. 
 
You should have another table where each record lists each drop-down value and the value you want it to say. For example, the info in your previous post would mean that there is a table with three records in it. If that can be done, then add this table to your data sources and link to it using the _7850... field. Then just put the second field on your report as the one to show the user. Since it is linked to the other data, everything stays in synch.
 
Does that help?
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
Angel
Newbie
Newbie
Avatar

Joined: 20 Aug 2008
Location: United States
Online Status: Offline
Posts: 4
Quote Angel Replybullet Posted: 21 Aug 2008 at 8:38am
Thank you for your help.  I found the table and am able to bring over the data that I want to see which is great, but I need to pull more then one value from that table into my report.  The table is just a list of every value that we have added.. is there anyway to bring multiple values into a report or am I limited to one?

Thank you so much!!
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.016 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.