I have gone over the chapter, and have worked out to do the counting of
the records using parallel reports and this works as expected, so that
the where an order number has two persons ordering then I can print out
the extra text I described in my original problem but only where there
is more than one person ordering (using a if statement taking the value
from the first parallel report)
However I am still having one problem is that wherever I place the
printing of the variable which taking the value from the first parallel
report, it is repeated twice
"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 [ ]
and also present the same time was"
The "and also present the same time was" is printed twice (which is
controlled by the variables used to count etc).
I am not sure how to control this so that "and also present the same
time was" is only printed once.
Looking the rest of the chapter I could not work this out. Help with
this would be greatly appreciated it.
Victor Warner
Ralph Alvy wrote:
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
