| Report Paramers in BIRT [message #198330] |
Wed, 07 March 2007 14:13  |
Eclipse User |
|
|
|
Originally posted by: lsadhu_bos.yahoo.com
Hello, I need to use same report parameter again and again at several
places in my script, can any one tell me how to do it. Like for eg in
below I use as of date at different places.
select medid, denid, p.name
from participant p,
(select medid from health where healthtype = 1 and
recdate <= to_date(:asofdate, 'mm/dd/yyyy')),
(select denid from health where healthtype = 2 and
recdate <= to_date(:asofdate, 'mm/dd/yyyy')) where
p.partid = medid(+) and
p.partid = denid(+) and
p.recdate <= to_date(:asofdate, 'mm/dd/yyyy')
thank you.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.08256 seconds
Home