I am still trying to solve this issue. I have been over Ralph's chapter
on subreports and the chapter on iteration control and I just cannot get
this seemingly simple thing to work, even with some of the
methods/suggestions in the Iteration control chapter.
I can use the parallel report technique to count the records and get
that result placed where I wish in the report, but still cannot work out
the following:
1. That where there are two records to be printed (using a sub report),
2. after the first printing of the first record, some text is printed, but
3. that text is not printed after the second record is printed.
This advanced stuff is new and difficult for me to grasp. Help with this
would be really appreciated.
Victor Warner.
Victor Warner wrote:
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
