Solved

crystal report

Posted on 2011-03-14
5
348 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
  • 3
5 Comments
 
LVL 22

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 22

Accepted Solution

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

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 22

Expert Comment

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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now