Range of data between two parameters

[GNZLSA]

How do I setup multiple parameters to get data between
two range points?

In Acutauate Designer 5 SP2 (connect Oracle 8i)
I am trying to report rows within a date range.
User should be able to specify FromDate and ThruDate as
input parameters.

DataStream comes from the Textual Query Editor.

SELECT B.BATCHDATE,B.BATCHNUMBER
FROM BATCHINFO B
WHERE B.BATCHDATE BETWEEN :FROMDATE AND :THRUDATE

So far I am only able to successfully run this much

SELECT B.BATCHDATE,B.BATCHNUMBER
FROM BATCHINFO B
WHERE :?FROMDATE

Is there an easy solution or is this really complex in Actuate?
GNZLSA

 

[keithcorbin]

It is not that hard....I recomend overwriting the obtainSelect method and appending the where clause you need. Your parameters should be set as global variables and all you need to do is write the dynamic where clause.

If you need more help, email me I can send an example we do this very thing all the time.

K