Records

[concombre]

HI,
I work on a database of a LIMS(Laboratory Information Management System).
I have two tables on the database.One store a list of samples with different informations.This table is linked to a second table by the fied SampleCode(primarykey).A field in this table is a 'memo' field and store some notes.
When you use the LIMS, you can register some different types of notes or not, associed to a sample.With a sample you can have one, two, three or no not.The different notes are differencied by a number field in the second table.
The record corresponding to the sample is created inside the second table only when you register a note .
In the report, I want have a list of sample with one type of notes if it exist, function of the field number.Sample with no notes must appear too.

Thanks for your help

fred

 

[Roadkill150]

in your table linking expert, make sure the link you have is not set at "equal join" but rather left outer or right outer join. (basded on which side the sample table is on).
This will return all samples even if there isn't corresponding data in the other table
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[concombre]

The link I have is set 'left outer'.
But I must have a filter on details section function of the field of the second table.
When i make a filter using a field of this table, if the sample has no notes (so no record in the second table),the record disappear.Only the sample with a note appear.

How can I do to have all records?


FRED

 

[kenhamady]

A filter on the 'outer' table nullifies the outer join. You have 3 choices:

1) use subreports to get the details for each group (slow)
2) drop the filter from selection and suppress the details you don't want to see. Use formulas to get correct totals.
3) Somehow ensure that groups with no valid details have one detail record that can be included. This could be by adding dummy data, or by expanding the selection critiera to include details that are in every group. 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