Tim,
Thank you very much for the response and the detailed explanation.
Exactly what I wanted to do.
Victor Warner.
Tim Rude wrote:
Oops, slight correction:
Remove the semicolon before P1F3 in the line that assigns the value to
RV1, making it:
{Assign RV1: cat.t[P1F2;", "P1F3;","]}
Otherwise the cat.t will strip out the space after the comma.
----- Original Message -----
From: "Tim Rude" <[email protected]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Monday, January 12, 2009 8:28 PM
Subject: Re: [Dataperf] Problem with producing desired report
Victor,
Assuming fields are numbered as follows:
P1F1 = key
P1F2 = composer name
P1F3 = piece name
P1F4 = catalog number
P2F1 = key
P2F2 = piece details
Base the following report on Panel 1:
--- First Page Header ---
--- Other Page Header ---
--- Two Level Report Header ---
--- Report Body ---
{Assign RV1: cat.t[P1F2;", ";P1F3;","]}
{Assign RV2: 1}
--- Subreport to Panel 2 (linking on key field) ---
{Print RV1 as A78;;B} {Print P2F2 as A78;;B}
{Assign RV2: 0}
--- End of Subreport ---
--- Skip if RV2 is False (0) ---
{Print RV1 as A78;;B}
--- Two Level Footer ---
--- Page Footer ---
--- Final Footer ---
In your example of the output desired, there was an extra trailing
comma
after the "Alkan, Etude," detail-less entry. I assumed this was a
typo.
If not, you can tack on an extra comma when you print RV1 after the
'Skip' line.
Tim Rude
----- Original Message -----
From: "Victor Warner" <[email protected]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Monday, January 12, 2009 5:24 PM
Subject: [Dataperf] Problem with producing desired report
I am having difficulty in producing a report and would be grateful
for
some help.
The database consists of 2 panels:
1. Panel 1: an incrementing key field, name of composer, name of
piece,
catalogue number
2. Panel 2: is linked to Panel 1 by the key field, details for a
particular name of piece.
To give an example:
In Panel 1:
Key field, composer, name of piece, catalogue number
1, Alkan, Etude, cda67654
2, Alkan, Piano Sonata, cda67654
In Panel 2
For record 1 in Panel 2 there would be no records, but for record 2
from
Panel 1 there would
be several records, eg
key field, details
2, 1st movement
2, 2nd movement
2, 3rd movement
What I am struggling is in produced a report formatted to text which
is
formatted as follows:
composer (from panel 1), name of piece (from panel 1), details (from
panel 2).
The problem is that the name of piece field for some records only
need
to be appear once (if
there are no linked records from panel 2), but in some cases needs
to
be
repeated several times
if there are several linked records in panel 2 (that is if I am
trying
to produce the report
starting from the panel 1), but if I am producing the report from
panel
2, the problem is that
because some records do not have related records in panel 2, then
they
would appear in a
report started from panel 2.
To develop the example given above, the final report I wish to
create:
Alkan, Etude,,
Alkan, Piano Sonata, 1st movement
Alkan, Piano Sonata, 2nd movement
Alkan, Piano Sonata, 3rd movement
Help with this would be greatly appreciated.
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
|
