Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Getting segment description in CR Post Reply Post New Topic
Author Message
woyla
Newbie
Newbie
Avatar

Joined: 14 Aug 2008
Location: Cameroon
Online Status: Offline
Posts: 2
Quote woyla Replybullet Topic: Getting segment description in CR
     Posted: 14 Aug 2008 at 10:00am
Dear all,

This is probably a basic syntax for those who use to use Crystal Report, but I'm not that one. So please, can someone tell me how to get in a CR report, a line giving a field and its description next to it?
 
To be more precise: 2 tables. In the first table I can get a list of field's value, for example 1234. That 1234 code has a description, for example "1234 = used cars". But code descriptions are in the second table. I know how to do the links, etc. But what is the syntax to get on each line, the code, and then the description next to it?

Thanks.
woy
IP IP Logged
saoco77
Senior Member
Senior Member


Joined: 26 Jun 2007
Online Status: Offline
Posts: 104
Quote saoco77 Replybullet Posted: 14 Aug 2008 at 11:55am
Create a formula similar to this and place it on the report.

if ({table1.CodeField}={table2.CodeField}) then
{table2.CodeDescription}

Sarah
IP IP Logged
woyla
Newbie
Newbie
Avatar

Joined: 14 Aug 2008
Location: Cameroon
Online Status: Offline
Posts: 2
Quote woyla Replybullet Posted: 19 Aug 2008 at 3:11am
Hi Sarah,
 
Thanks for your reply. I'll give it a try and will let you know.
 
Thanks again.
woy
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