Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Dumb Question Post Reply Post New Topic
Author Message
jeffwest1
Newbie
Newbie
Avatar

Joined: 25 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote jeffwest1 Replybullet Topic: Dumb Question
    Posted: 25 Jun 2007 at 2:42am
I have used CR for a long time, however I haven't used it for a while, The company I wiork for has just let me loose on CR-XI Tongue
 
Anyway, my stupid question, I have two tables
 
Table one has a code, that matches in table two, i want the description from table 2 in my report.
 
I have forgotton how to do this as a formula, the ones I thought it was don't work, and although my SQL is pretty good, the SQL expression doesn't seem to want to know. Angry
 
Any hekp would be appreciated.


Edited by jeffwest1 - 25 Jun 2007 at 2:43am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Jun 2007 at 10:39am
If you join the two tables on that code, the field in the second table that has the description will appear in the Field Explorer window. Is this not what you want?
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
jeffwest1
Newbie
Newbie
Avatar

Joined: 25 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 13
Quote jeffwest1 Replybullet Posted: 26 Jun 2007 at 7:19am
Sorry, i was being dumb, the way the tables are joined was making things very difficult, as I wasn't quite sure what the joins actually where.
 
I have kinda solved my problem.
 
Thanks anyway.
C-3PO: Excuse me sir, but might I inquire as to what's going on?
Han Solo: Why not?
C-3PO: Impossible man.
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.