Skip to Content
0
Former Member
Sep 13, 2007 at 02:05 PM

an odd formula

28 Views

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