Go over the section in my book called Subreports and Subroutines. There is
extensive discussion there on using subreports to gather data before
actual printing starts, using parallel reports, dummy reports, etc.
On Fri, 21 Sep 2007 15:18:56 -0700, Victor Warner
<[EMAIL PROTECTED]> wrote:
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
