Crystal Reports Using Join ?

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Using Join ?

Post Reply

Post New Topic

Author	Message
gv123 Newbie Joined: 27 May 2009 Online Status: Offline Posts: 4	Topic: Using Join ? Posted: 29 May 2009 at 8:07am
	I want to be able to do this in my report If {table1.BillState}='CT' then "Connecticut" ( COnnecticut should come from other table) I want to have this query : SELECT State.Descr,POReqHdr.State from table1 LEFT OUTER JOIN table2 ON table1.BillState = table2.StateProvI How to approach this?
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 29 May 2009 at 9:05am
	YOu can add the two tables to your report via the Database Expert. Within the DB Expert you can create the left outer join option on the Links tab. The Select part of the statement is not needed. If you use the DB Expert all fields from either table will be available for use in the report. Not knowing your data I assume this join will essentially make your desired result of 'CT' ="Connecticut".
	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