Post Author: kskipper
CA Forum: Formula
I have a report that is intended to generate invoices. In the data files, there is a file for comments. The structure of that file is as follows:
Invoice number, line number, comment sequence, comment.
and the data might look like this:
123456,0,1,Shipped on 08/30/07
123456,0,2,Package #1
123456,0,3,Pkg weight 25
123456,0,4,Tracking Number 9987745611
123456,0,5,End Shipment
For each invoice number, there can be multiple line numbers, so each line item on the invoice can have comments associated with it. If the line number is 0, as in the above example, the comments are considered 'header comments' and are not associated with a particular line item and print elsewhere on the report/invoice.
What I want to do for the header comments is to concatenate the Package #, weight, and tracking number comments together onto one line (to reduce the number of lines on the invoice.
Currently my report looks somethign like this:
page header,
group header #1a (invoice number)
group header #1b to group header #1e (address lines, so I can supress a blank line)
group header #1f (contains a subreport that generates the line items)
details (header comments)
group footer #1a (supressed)
group footer #1b (totals and disclaimers)
When an invoice is generated the details sections appears as follows:
Shipped on 08/30/2007
Package #1
Package weight 25
Tracking Number 977866546546
Package #2
Package weight 30
Tracking Number 7786651313213
End Shipment
What I would like to see is:
Shipped on 08/30/2007
Package #1, Package weight 25, Tracking Number 977866546546
Package #2, Package weight 30, Tracking Number 7786651313213
End Shipment
Does anyone have any insight into how I can get this done?
Thanks for any assistance.
Karen