?
Solved

crystal report

Posted on 2011-03-14
5
Medium Priority
?
354 Views
Last Modified: 2012-05-11
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
Comment
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
  • Learn & ask questions
  • 3
5 Comments
 
LVL 23

Expert Comment

by:Ido Millet
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

by:
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

by:mlmcc
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

by:mercybthomas74
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

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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month13 days, 21 hours left to enroll

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question