Re: Re: How to count records in a report

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 
> <vwarner-0bo+QMkBU69BDgjK7y7TUQ@xxxxxxxxxxxxxxxx> 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
> Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> http://lists.dataperfect.nl/mailman/listinfo/dataperf