Hi Michael,
DP has some special ways of handling multiline Text Fields in reports.
Especially useful in report with parallel text fields.
To print out the entirety of an Alphanumeric variable length text field
instead of using the same indicator as on the panel you would use an
indicator like A20A0.
But lets say you had two Alphanumeric text fields, to output across the same
line. If you output them on the same line with a format indicator like
P1F1:A20A0 and P1F2:A30A0 instead of them being on the same line the P1F1
field would print out entirely and then the P1F2 field would start printing
on the line below, (or maybe start on the last line of the P1F2 field, I
can't remember which)
DP Has a special format which allows printing of individual lines, so A20A1
prints the first line of a field. It then increments a pointer so that if
you again printed the same field with the format A20A1, it would print the
next line, etc. Once you have done this then A20A0 prints out the remainder
of the field
So to print to aligned text fields you would do this
F1:A20A1 F2:A30A1
F1:A20A1 F2:A30A1
F1:A20A1 F2:A30A1
F1:A20A1 F2:A30A1
F1:A20A0
You might immediately see a problem - what if you want to print the same
field again in the report. That is handled by the Print Mode Indicator ;;N
which indicates a new occurrence of the field
So for example lets say you had an address stored in a MultiLine text field
and you need to output it, say for example to an XML file and they were a
maximum of 3 lines long
<Address>
<Line1>
F1:A50A1;;N
</Line1>
<Line2>
F1:A50A1
</Line2>
<Line3>
F1:A50A1
</Line3>
</Address>
Hope this help
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Michael Iannantuoni
Sent: Thursday, 22 April 2010 6:08 AM
To: DataPerfect Users Discussion Group
Subject: [Dataperf] subfield problem
I have a multi-line text file which is formatted as A38A6 and want to
split it into individual lines.
In a report I have a number of Report variables set as follows: RV4n set
to subfield[P1F4;0;n] where n = 1 to 6.
I then print the six Report Variables as A38 but they randomly miss some
of the data from the original A38A6 field.
Two examples are shown below:
Joy Griffin
Treasurer, Cottesmore Social Club
1 St Nicholas Court
Cottesmore
Oakham
Rutland LE15 7BW
comes out as
Joy Griffin
Treasurer, Cottesmore Social Club
1 St Nicholas Court
Cottesmore
O
and
Greetham Valley Hotel, Golf and
Conference Centre (attn Sharon)
Wood Lane
Greetham
Oakham
Rutland LE15 7SN
comes out as
Greetham Valley Hotel, Golf and Confer
Wood Lane
Gree
Can any help please?
Thanks,
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
