I would be grateful to know whether the following is possible, where
1. I have a panel which is contains an order number (Panel 1).
2. Another panel contains the details of what is ordered (Panel 2)
3. A third panel contains the name of address of the person(s) ordering (Panel
3)
4. There is a link between Panel 1 and Panel 2 (based on the order number) and
a link
between Panel 2 and Panel 3 (based on a customer number).
5. For each order there can be two or more customer records.
In a report I have created which uses subreports (in the order Panel 1, 2 and
3) where
there is one customer then the report works fine, but where there are two
customers for the
one order their is a slight variation I would like to make a slight change but
cannot work
out how to do it.
To be specific, in the report, when producing details from Panel 3, there is
stated where there is one
customer:
"John A Smith, date of birth [ ], residing at [] and identified by his British
passport [ ]
etc"
which is what I want.
If there are 2 customers then two sets of details are reproduced, eg
"John A Smith, date of birth [ ], residing at [ ] and identified by his British
passport [ ]
etc
Jane B Smith, date of birth [ ], residing at [ ] and identified by her British
passport [ ]"
Again this is what I expect to see, however there is one addition that I wish
to make
which is to add some additional wording between two sets of details. What I am
looking
for is it possible to carry out a count of the number of records which are
present against
the particular order number and if there is 2 of them then add the additional wording.
eg
"John A Smith, date of birth [ ], residing at [ ] and identified by his British
passport [ ]
etc
and also present the same time was
Jane B Smith, date of birth [ ], residing at [ ] and identified by her British
passport [ ]"
Victor Warner.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
