Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

crystal report

Posted on 2011-03-14
Medium Priority
358 Views
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
Question by:mercybthomas74
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3

LVL 23

Expert Comment

ID: 35131776
({?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

LVL 23

Accepted Solution

Ido Millet earned 2000 total points
ID: 35131787
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

LVL 101

Expert Comment

ID: 35131822
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

Author Comment

ID: 35131899
i am trying to filter with parameter selction, tried the above code , did not work, pull all records even after selecting the parameter
0

LVL 23

Expert Comment

ID: 35132094
Show the expression you have in the record selection criterion.
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month8 days, 21 hours left to enroll