Vicki Dearduff
Member
I am using the reports section in PL/SQL developer. One of the variables that I need to have is for state. I need for the person to be able to select just 1 state, a mixture of states or all states. I can do the 1 state and all states using the ifempty. I don't know how to get them to be able to select a mixture of states without them having to manually type in each state. Here are the two different coding options that I am using but they have to pick a different report file depending on if they want to select just one state or enter in multiple states.
and ascrt.fac_st in &< name = "State Code"
hint = "Enter as ('??', '??') or leave blank for all"
ifempty = "('FL','AR','NM','WI','WY','DE','VA','LA','NE','ND','CA','MA','TX','WA','NV','IN',
'MI','MN','PR','SC','NY','VI','MO','WV','ID','KY','OK','SD','DC','AZ','MD','TN','UT','PA','ME','IL','CO','NC','OR','AK','NJ',
'AL','CT','MS','MT','NH','OH','GA','IA','RI','HI','KS','VT','CN','VI','GU')" >
and u.state_cd like &< name = "State Code"
list = "select distinct state_cd from csp_user where state_cd is not null and state_cd ' ' order by state_cd"
type="string"
ifempty = "%" >
and ascrt.fac_st in &< name = "State Code"
hint = "Enter as ('??', '??') or leave blank for all"
ifempty = "('FL','AR','NM','WI','WY','DE','VA','LA','NE','ND','CA','MA','TX','WA','NV','IN',
'MI','MN','PR','SC','NY','VI','MO','WV','ID','KY','OK','SD','DC','AZ','MD','TN','UT','PA','ME','IL','CO','NC','OR','AK','NJ',
'AL','CT','MS','MT','NH','OH','GA','IA','RI','HI','KS','VT','CN','VI','GU')" >
and u.state_cd like &< name = "State Code"
list = "select distinct state_cd from csp_user where state_cd is not null and state_cd ' ' order by state_cd"
type="string"
ifempty = "%" >
