Print Page | Close Window

Left Outer Join with a Constant String

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1064
Printed Date: 02 May 2024 at 9:28pm


Topic: Left Outer Join with a Constant String
Posted By: newbie
Subject: Left Outer Join with a Constant String
Date Posted: 25 Jul 2007 at 2:48pm
Hello,
 
I need to include "LEFT OUTER JOIN" with a constant string in "Record Selection Formula" editor for a report.
 
{Table_Name.column_name} (+) = "SEP"
 
Any ideas how to do this.
 
Thanks
VK


Replies:
Posted By: jkwrpc
Date Posted: 25 Jul 2007 at 5:50pm
I am not certain exactly what you are trying to do here.
 
If you need to do a left outer join which is typically done between data tables, I suggest you use the database expert and create a command object. The command object is really a place for the SQL query which can include the LEFT OUTER JOIN.
 
If you simply want to join the column value to  to  = SEP here is an example
 
----------------------
ToText({Credit.Customer Credit ID}) & "= Sep"
 
returns  something like
 
"1234 = Sep"
-------------------------------------
 
Hope this helps.


-------------
Regards,

John W.
www.CustomReportWriters.net


Print Page | Close Window