Jump to content

Stop query returning all results on 0=0 when using $X{IN} in multi select input controls


jasperUser12

Recommended Posts

I have some cascading input controls setup on my report. Data is customer specific and the 'master' control they can use is restricted based on their login. If we call the main control master1 and the two slave controls slave1 and slave2, slave1 and slave2 are populated based on the value of master1. If I deselect the value in master1 then the $X{IN, column, master1} control evaluates to {0=} (true) and the WHERE filtering is useless and all results are returned.

Is it possible to invert this behaviour and make it so a null value in master1 means nothing is populated in slave1 and slave2?

master1slave1slave2
Ajohnutah
Asteveniowa
Bfrankohio
Bkellynew york



So if A is selected in master1 then slave1 has choices of john and steven and slave2 has choices of utah and iowa. Similar for master2 being B - slave1/slave2 = frank and kelly/ohio and new york. If I don't select A or B in master1 then slave1 and slave2 have all available choices so john,steven,frank,kelly and utah,iowa,ohio,new york.

All inputs are multi select checkboxes and java.util.Collection types.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

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