Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

crystal report

i have the parameters values as:

All CTE codes
CTE codes 2 and 3
CTE Code 1

The Field that contains these code :CTEcode

I have the condition for this parameter, its not working

If CTEcode = '1' then 'CTE Code 1'
else
If CTEcode in ('2','3') then 'CTE codes 2 and 3'
else
If CTEcode in ('0','1','2','3','4', "") then 'All CTE codes'

the last condition is not working if All CTE codes is selected show all , that what i want.... not giving me the result...
 
0
mercybthomas74
Asked:
mercybthomas74
  • 3
1 Solution
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
({?Your_Parameter} = 'All CTE codes')
OR
({?Your_Parameter} = 'CTE Code 1' AND ({CTEcode} = '1' OR {CTEcode} = '2'))
OR
({?Your_Parameter} = 'CTE codes 2 and 3' AND {CTEcode} = '1')
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Sorry, I meant:

({?Your_Parameter} = 'All CTE codes')
OR
({?Your_Parameter} = 'CTE Code 2 and 3' AND ({CTEcode} = '2' OR {CTEcode} = '3'))
OR
({?Your_Parameter} = 'CTE codes 1' AND {CTEcode} = '1')
0
 
mlmccCommented:
What are you trying to do?
Are you trying to filter based on the parameetr value?
If so then the above is close

({?Your_Parameter} = 'All CTE codes')
OR
({?Your_Parameter} = 'CTE Code 1' AND {CTEcode} = '1' )
OR
({?Your_Parameter} = 'CTE codes 2 and 3' AND ({CTEcode} = '3' OR {CTEcode} = '2'))

If you are trying to do something else then please explain

mlmcc
0
 
mercybthomas74Author Commented:
i am trying to filter with parameter selction, tried the above code , did not work, pull all records even after selecting the parameter
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Show the expression you have in the record selection criterion.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now