Sage 100

I have a Crystal Report where we want to format data for a single sales order where they **could** be up to three invoices. They want to see: Sales Order #, Ship To Name, Ship To State, PO #, Invoice #1 $, Invoice #2$, Invoice #3$ I'm able to get the report ok until it comes time to print the list of invoices horizontally. I'm linking: SO_SalesOrderHistoryHeader -> AR_InvoiceHistoryHeader ->AR_TransactionPaymentHistory I'm stuck on how to get the list of up to three invoices to show to the right (horizontally) -- thoughts?

Wayne, Can you get the invoices to print vertically (on different group headers or footers)?

How about a cross-tab report, with Invoice # as a column? What are you using AR_Transaction for? If there are NO invoices, should the order # still print? If not, maybe drop SO_SalesOrderHistoryHeader and pick up SO# from AR_InvoiceHisoryHeader?

I was using the Trans file in order to duplicate the records with an equal join but I see that I can take it out and change the query slightly and get the same result.

Why do you need SO_SalesOrdderHistoryHeader? The SalesOrderNo and ShipTo data are in AR_InvoiceHistoryHeader. Either way, you could group your report by SalesOrderNo and in the hidden detail accumulate the invoice amounts into a shared string variable for display on the Header or Footer.

I have done the following with serial numbers, maybe this will work? Create a sub report, format the details section with multiple columns.

@DanBurleson I'd need SO_SalesOrderHistoryHeader if they wanted the report to show any orders that had not yet shipped.