coltae Posted September 15, 2015 Share Posted September 15, 2015 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 Link to comment Share on other sites More sharing options...
RamaKrishna.B Posted September 16, 2015 Share Posted September 16, 2015 hican you explain the issue in detail so that i can help you Link to comment Share on other sites More sharing options...
zh3ntil Posted September 16, 2015 Share Posted September 16, 2015 Jasper Query: SQL Query:where $X{BETWEEN,column_name,param1,param2} -----> where column_name>param1 and column_name<param2where $X{[bETWEEN,column_name,param1,param2} -----> where column_name>=param1 and column_name<param2where $X{BETWEEN],column_name,param1,param2} -----> where column_name>param1 and column_name<=param2where $X{[bETWEEN],column_name,param1,param2} -----> where column_name>=param1 and column_name<=param2 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now