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
