That's great. That result is what we're about in this group!
Don
Plus a little sharing of ideas !
Victor Warner wrote:
Don,
Thank you for this further explanation. It now works just as I wanted..
Thank you again.
Victor Warner.
Don Codling wrote:
See comments in your text. There are other ways to do this, but this
seems to me to be the simplest and clearest.
Don
Victor Warner wrote:
Don
I am sorry but I am failing, somewhere, to understand some part of
your suggestion. I am almost a complete novice for this more
advanced stuff. I would like to go over this procedure again with a
few queries:
1. First, right at the top of the report, I create rv 250, just with
""
in it (no space between the question mark)
Yes
2. right at the start of the report body of the sub-report, I print
the rv 250, and set "Eliminate Line if Blank".
Yes
QUERY: what should the format of this rv be, if it only contains
nothing? Should it is still be A0A0;;T
Yes. That format allows for multiline text in your variable, but
includes nothing after the last character in your variable (that's
the purpose of the ";;T"). At the beginning, when RV250 = "" there
will be nothing to print in the RV, so you will skip that line in the
Report and not leave a blank line there.
3. Then follows the fields from the panel used for the sub report
(plus any other text) etc
Yes
4. At the end of the report body of the subreport I "set RV250 to
the text you want between your records, i.e. to "
and also present the same time was "
QUERY: This part I am obviously lost here. Do I print the RV250
again with the format A0A0;;T and then just type the text I wish to
include in the report of the sub-report after printing RV250?
No, you do not print RV250 here. If you do, you will get it printed
twice with each subsequent record that is selected, once before and
once afterward. Instead you define a new report variable (in the same
way you defined it in the beginning except that here you give it the
text you want between your records, and when you are asked for the
number, you number it 250. The values you have entered for it then
replace whatever was in RV 250 before, so that when it prints with
the next record, you get the text you want between your records.
Victor Warner.
body, before anything else I printed report variable 250 with a
format of A1 and set "Eliminate Line if Blank"
Don Codling wrote:
September 25, 2007
If your report of what you did is correct, & I understand it
correctly, you are not printing the report variable, but text you
previously had in your report, so it comes out the same way.
You set your report variable size as A1 - that will give you only 1
character of your report variable, at best. I would suggest an
A0A0;;T format. Alternatively, An;;T where n is the number of
characters in the longest insert you would use, or more. It is
important to add the truncate code, because otherwise your blank
line will always print for the first record. Without the truncate
code, DP automatically fills in whatever you have in the variable
with spaces, so it will see a non-blank line.
And delete the text you had previously in the report to give you
this extra line.
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Victor Warner wrote:
Don,
This is what I did
1. First I created a report variable 250, just with
""
in it (no space between the question mark)
2. Then in the report body, before anything else I printed report
variable 250 with a format of A1 and set "Eliminate Line if Blank"
3. At the end of the report body, created another report variable
250 with the following
"and also present the same time was"
4. Then printed the report variable.
I assume these are the steps, but the result is still the same,
the text still gets printed twice
Victor
Don Codling wrote:
September 25, 2007
Hi Victor
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?
I think it should work in either place, but I would put it right
at the top of the report, to be sure.
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?
The first item in the sub-report body because you want it to
"print" with every record that is printed.
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?
Again, in the sub-report body, because you want it to change with
the first record that is chosen, so that it prints your text with
all further records.
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Victor Warner wrote:
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
_______________________________________________
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
