Jump to content

Recommended Posts

Posted

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) >= null

AND  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.

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted

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>})

 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...