What are the expressions I should use? How do I link the range to the respected variables? Example "Date created" and "Date Finished" need to be the To and From parameters?
Thank you for any help!
-Colt
1 Answer:
Posted on September 16, 2015 at 12:27am
Jasper Query: SQL Query:
where $X{BETWEEN,column_name,param1,param2} -----> where column_name>param1 and column_name<param2
where $X{[BETWEEN,column_name,param1,param2} -----> where column_name>=param1 and column_name<param2
where $X{BETWEEN],column_name,param1,param2} -----> where column_name>param1 and column_name<=param2
where $X{[BETWEEN],column_name,param1,param2} -----> where column_name>=param1 and column_name<=param2
hi
can you explain the issue in detail so that i can help you