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
