MultipleRecords

[rekhatr10]

Hi everyone,

I have 4 table
master(acct)->charge->claim
master(acct)->orders

I have 2 links going from master one to charge and other orders. The problem is I get multiple orders how can I limit it to just 1 order or is ther a better way of handling this

Rekha

 

[synapsevampire]

That depends on your version of Crystal,the database used, join types, and other technical issues. If you have a dba, consult them. Crystal is a relatively easy product to use, and hence gives the illusion to many that they don't need to understand data, but this is not the case.

Otherwise you might use a subreport for the Master(acct)->Orders portion.

If there are multiple orders, how would you determine which of them you want to display?

perhaps you mean that you're getting the same order numerous times?

A short text description isn't very useful, please provide technical information if the above doesn't help:

Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[rekhatr10]

K

CR 7.0
SQL 2000

You are right. I am getting the same order numerous times. I have a older version of crystal.
exampleData:
20692 POSBORNE 28/5/04 36415 364158 780.6 VENIPUNCTURE
20692 POSBORNE 28/5/04 87186 871863 780.6 SENSITIVITY MIC
20692 POSBORNE 28/5/04 36415 364158 780.6 VENIPUNCTURE
20692 POSBORNE 28/5/04 87186 871863 780.6 SENSITIVITY MIC
20692 POSBORNE 28/5/04 36415 364158 780.6 VENIPUNCTURE
20692 POSBORNE 28/5/04 87186 871863 780.6 SENSITIVITY MIC

Expect Data:
20692 POSBORNE 28/5/04 36415 364158 780.6 VENIPUNCTURE
20692 POSBORNE 28/5/04 87186 871863 780.6 SENSITIVITY MIC

I have date parameter as the record selection. If you could direct me in the right direction I would appreciate it.

REkha