Topic: Using Parameter in Join clause 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)
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
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.
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 ?
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
IP Logged
