How To Print Notes
There are many times when you may want to print a report with Client or Debtor Notes. Collect! has
two methods for retrieving Note lines in a report.
- Client or Debtor Notes loop
- Note Block
Client Or Debtor Notes Loop
Generally, if you are just printing Notes for Clients you can use the @cl.no loop. For Debtor Notes,
you can use the @de.no loop.
Each line in Notes is a separate record. You would loop through the Notes and print each line. You
can do this with Client Notes or Debtor Notes. If you specify the character limit, you can ensure
that you print each complete line.
Printing Client Notes
@cl.no is a loop, not a field. Each line in Notes is a separate record. @no.te is the code for each
line. <132> is the formatting code to control how many characters are printed for each line.
132 is the maximum that can be typed on a line.
Start On: Client
@cl.na
@cl.no
@no.te<132>
@cl.no
You can also nest the @cl.no loop inside an @cl loop to process several accounts in the same report.
Start On: Anywhere
@cl no total
@cl.na
@cl.no
@no.te<132>
@cl.no
@cl
You can also use the Note Block Printing method described below for more detailed reporting
needs.
Printing Debtor Notes
@de.no is a loop, not a field. Each line in Notes is a separate record. @no.te is the code for each
line. <132> is the formatting code to control how many characters are printed for each line.
132 is the maximum that can be typed on a line.
Start On: Debtor
@de.nav
@de.no
@no.te<132>
@de.no
You can also nest the @de.no loop inside an @de loop to process several accounts in the same report.
Start On: Anywhere
@de no total
@de.na
@de.no
@no.te<132>
@de.no
@de
You can also use the Note Block Printing method described below for more detailed reporting
needs.
Note Block Printing
If you want to print Notes with criteria, you can use the Note Block. The Note Block is a special
Report Writer structure for parsing Notes. This enables you to apply search criteria when printing
Debtor or Client Notes. This is very useful for filtering Notes when reporting account activity.
You can retrieve note lines with a particular Status, Operator, Date/Time range, for example.
To use the Notes Block method, simply create an @nb loop. @nb stands for "Note
Block" and will process the Notes for either the current Client or the current Debtor.
Start On: Debtor
@nb
@nb.da< @nb.ti< @nb.st< @nb.op< : @nb.te<
@nb
In this example, @nb is the Note Block loop initiator and terminator. The other
printable information codes are:
@nb.da (Date)
@nb.ti (Time)
@nb.st (Status)
@nb.op (Operator)
@nb.te (Text)
In the report, Collect! will put each valid note line on a separate line. A valid note line starts
with one or more asterisks "*" or it is a Date/Time stamp followed by an optional Status or Operator
ID. A Date/Time tag must be terminated with " : " for it to be recognized as a new note line. If
Collect! cannot recognize a note line as a new note, it will add the line to the end of the previous
note in the report output.
The maximum amount of text that will be read for each note line is 4095 bytes. If a single Note is
longer than this, it will be truncated in the report. Only the first 4095 bytes will be rendered.
@nb.te displays displays the text portion of the Note Block. Unlike @no.te, It will not
output any Date/Time, Status or Operator information. You must use the individual @nb
printable information codes to output that information.
You can nest this loop inside a Client loop or a Debtor loop to process notes from multiple accounts
in the same report.
Start On: Anywhere
@cl no total
@cl.na
@nb no total
@nb.da< @nb.ti< @nb.st< @nb.op< : @nb.te<
@nb
@cl
Note Block With Where Clause
You can use WHERE clauses on @nb.da, @nb.ti, @nb.st, @nb.op or @nb.te to filter results.
Start On: Anywhere
@de no total
@de.fi
@nb no total WHERE ( @nb.da = 01/01/2021 .. 01/31/2021 )
@nb.da< @nb.ti< @nb.st< @nb.op< : @nb.te<
@nb
@de
Note Block Text Parsing
The Note Block gives you a powerful tool for parsing text. This feature greatly simplifies searching
Notes for key indicators or information.
For example, the following snippet will give you the note lines with an address change.
Start On: Anywhere
@de no total
@nb no total WHERE ( @nb.te = Old Debtor->Address )
@de.fi< @nb.da< @nb.ti< @nb.st< @nb.op<: @nb.te<
@nb
@de
Technical Notes
In the Note Block printable information codes, @nb.n1 - @nb.n6 are unused. Each one represents a
separate 128 byte text buffer.
Note block parsing does not parse Time milliseconds. If you have enabled "Write millisecond notes"
in Screen and Messages, Collect! will simply ignore the milliseconds when outputting the @nb.ti value.
|
Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.
Please click this link to send us your comments: helpinfo@collect.org