Print Page | Close Window

Using Parameter in Join clause

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14287
Printed Date: 22 Apr 2025 at 4:06pm


Topic: Using Parameter in Join clause
Posted By: GrizzlyAdams
Subject: Using Parameter in Join clause
Date Posted: 07 Sep 2011 at 2:59am
Is it possible to use Parameter in Join clause without using a stored procedure as datasource ?

ie
LEFT OUTER JOIN database."dbo"."table1" ON ("table1"."key"="table2"."key")
AND ("table1"."field"="table2"."field1")
AND ("table2"."field2"= ?reportParameter)


Replies:
Posted By: hilfy
Date Posted: 08 Sep 2011 at 7:27am
You could do this in a command, which is a SQL select statement that gathers all of the data for your report instead of selecting tables and linking them together manually.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: GrizzlyAdams
Date Posted: 12 Sep 2011 at 2:43am
I was able to add a SQL statement as a 'Command' in Database Expert.  I can see the Command and Right-Click to add to Repository... then it displays error message "Central Management Server" is not running on Port

Do I need to add to "Central Management Server" in order to use the Command as input to my report ?


Print Page | Close Window