Pei Hsuan Shen Posted March 17, 2020 Posted March 17, 2020 Case when '${CustomerSelect}' = 'All' then [NEW_CUST] = '1' or [NEW_CUST] = '2' when '${CustomerSelect}' = 'New' then [NEW_CUST] = '1' when '${CustomerSelect}' = 'Old' then [NEW_CUST] = '2' end The program can work. But the result is not as good as my thoughts. When '${CustomerSelect}' = 'All', I want the table to show whole the data. But the table always shows blank. Can you tell me how to fix it Thank you.
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