macaxrc Posted April 5, 2015 Posted April 5, 2015 Hi guys!I'm need more help, I use Japser Studio 5.5 and in my report I use 2 input controls in each chart and query. In each query I put the following condition AND date(post_created_at) >= $P{input_semana} AND date(post_created_at) <= ADDDATE($P{input_semana},6-WEEKDAY($P{input_semana})) As I said, I'm using two parametres input_semana is the first one and the second one is input_mes, the problem of this is that if I don't select input_semana the report it's blank becouse the conditions is this AND date(post_created_at) >= nullAND date(post_created_at) <= ADDDATE(null,6-WEEKDAY(null)) .Jaseper Studio has a easy form to solve this? I need that this query conditions only have effect when the input_control is selected.This is possible?Thanks.
srang Posted April 7, 2015 Posted April 7, 2015 You can give parameters default values that are prepopulated when the controls load up on the server. Another option would be to use IFNULL($P{param},<other_option>})
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