Don,
Thank you for the reply. Just a few queries.
1. "In the report header, set up a variable, call it variable 55, & set
it to "" ". Do I place this right at the top of the report? Not in the
header of the sub-report in question?
2. "As the first item in your subreport, print Var 55 a. Mark it
"skip line if blank" " Is this in the sub-report's header or report body?
3. "At the end of your subreport, set Var 55 to the text". Again is this
at the end of report body or the sub-report in the footer/final footer?
Victor
Don Codling wrote:
September 25, 2007
Here is a suggestion for your problem of printing information between
records selected in a subreport. I have not tested this, but I think
it will do what you want.
1. In the report header, set up a variable, call it variable 55, &
set it to ""
2. As the first item in your subreport, print Var 55
a. Mark it "skip line if blank"
3. At the end of your subreport, set Var 55 to the text you want
between your records, i.e. to "
and also present the same time was
". You may want added hard returns to give you the spacing you
desire
The effect of this should be to do nothing at the beginning of the
first record selected any time you run the report, because var 55 is
set to "".
But then the var is reset in the subreport to the text you desire &
will print before each selected record in your subreport. Nothing will
print at the end because it prints only at the beginning of the
printout of selected records.
I hope that helps.
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Victor Warner wrote:
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
