more than one detail section in a report

[Karen Jenny]

I am setting up a very complex report and soma of my data is missng. That is,
the query behind the report showes all records that i want but in the report
only som of them show. I think the problem is because some of my data is in
section header and not in the detail section. What I would like to be able to
do is to have more than one detail section in my report.

To explain a little better I want to summarize data for certain experiments
that are stored in 4 different tables.
1. Samples
2. Processed samples
3. Labeling
4. Hybe
Each Experiment has many samples, each samples may have been processed more
than once and then the processed samples have different barcodes.
Each processed samples may have been labeled more than once and each labeled
sample may have been hybed more than once.

I want to see all these record for each experiment.
THe query that I have made shows me all the records but some of the are
missing in the report.
I get all the samples.
Only the processed samples that have been labeled.
Only on labeled sample for each processed sample (though I know there are
more of them) is shown. and then all hybes even though they do not match with
the one labeled sample that is shown.

I hope someone understands my explanations.

Thanks
Karen Jenny

P.S. I apologize if my english is not good. I am writing from Iceland.

 

[Stefan Hoffmann]

hi Karen,

To explain a little better I want to summarize data for certain experiments
that are stored in 4 different tables.
1. Samples
2. Processed samples
3. Labeling
4. Hybe
Each Experiment has many samples, each samples may have been processed more
than once and then the processed samples have different barcodes.
Each processed samples may have been labeled more than once and each labeled
sample may have been hybed more than once.

Your query is a flat representation of your data. Create a group with
group header/footer for each entity:

Group Samples Detail
Sample Data
Group Labeling Detail
Labeling Data
Detail
Rest Data


mfG
--> stefan <--