Jump to content
We've recently updated our Privacy Statement, available here ×

When not selected input_control


macaxrc

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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