combine results from 2 tables

[203bravo]

I'm attempting to show the reults from a table on 1 line:
example

1st table

Customer# Customer_Name

2nd table
Customer# Invoice#
Customer# Invoice#

A customer from table 1 could have multiple active invoices in table 2.

I need the report to show

Customer_Name Invoice# Inovice# Invoice# etc

instead of
Customer_Name
Invoice#
Invoice#
Invoice#

thanks for your help and suggestions.

 

[lbass]

Link the tables on customer number. If you want to show all customers, even if they don't have an invoices, use a left join from the customer table to the invoice table. Otherwise use an equal join.

Try inserting a crosstab that uses customer as the row and invoice as the column. Not sure what you want to summarize, maybe amount? Try sum of invoice amounta as the summary. Place the crosstab in the report header or footer.

-LB

 

[Turkbear]

Hi,
This , from the Help file, should point the way

Multiple columns
Instead of having your data print straight down the page, you can set up multiple columns and have the data flow from column to column.

To create a multiple-column report
Open then report you want to format with multiple columns.
On the Report menu, click Section Expert.
Tip: Another way to do this is to click the Section Expert button on the Expert Tools toolbar.

In the Section Expert, highlight Details, and then select Format with Multiple Columns.
A Layout tab is added to the Section Expert.

Click the Layout tab and set the Width you want your column to be.
Keep in mind that the width of your paper when deciding your column width. For example, if you have three fields in your Details section, and they take up four inches of space, limit the width of the column to under four and a half inches so that all the field information can be seen.

Set the Horizontal and/or Vertical gap you want to maintain between each record in your column.
In the Printing Direction area, choose a direction.
If the report you're formatting contains grouping, select Format Groups with multiple column.
Click OK.
When you preview the report, you'll see that the field headers appear only for the first column. To have field headers for the second column, insert a text object.

To Paraphrase:"The Help you get is proportional to the Help you give.."