Record Selection Question

[EVM]

Hi all,
In order to use dynamic selection criteria, I type the following coding in the Record Selection Formula Editor:

{DatabaseField1} = {? Parameter1}
and
(
if {?parameter2} <> &quot;&quot;
then {DatabaseField2} = {? parameter2}
else 0=0
)

Although it can work, I don’t know whether I use the best method.
Do I use a correct method?? Is there any other method??
Thanks!!!

 

[kenhamady]

See my answer in the CR formula forum. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[juli5e]

How do I select only unique records in Crytal Report? For example, if my report is showing duplicate entries of record such as:

Workorder# Qty Sales Order Line#
1111 100 4555 3
1111 100 4555 3

How would I tell CR to just show me one record only if duplicate?

Thanks in advance

 

[kenhamady]

What version of CR are you using?
Do you know WHY they are duplicated? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[juli5e]

I am using CR8. Most likely due to some multiple linking but it would take too long to explain the inadequate databse structure (Manex). Yet, my results are showing up but it has multiple items that are the same.

 

[kenhamady]

It appears that you have already found the &quot;select distcint&quot; option from another thread. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com