Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Posted: 18 Dec 2008 at 4:18am
You can do this while writing the sql code in add command i,e while connecting to database itself you can create the parameters based on these parameter you can pass the value.
Joined: 15 Aug 2008
Location: United Kingdom
Online Status: Offline
Posts: 48
Posted: 18 Dec 2008 at 7:44am
I think you are trying to make it too difficult.
Just pull in:
Select DISTINCT ld_leg_id, 'OPN' AS status from LD_LEG_T where CUR_OPTLSTAT_ID =300 UNION Select DISTINCT ld_leg_id, 'TND' AS status from LD_LEG_T where CUR_OPTLSTAT_ID =320
then in the Section Expert - Details - Suppress put something like IF {?status} = status or {?status} = "*" then false else true
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