Hello,

I have a csv file I receive daily that has orders in it. This file has multiple records or one record per unique order. Some orders are 1 item per order. Others are several items per order. Each item record has an orderid that can be sorted on.

I need a report to print out one occurence of the customers details and all the items they ordered and then an order total by each orderid.

I have read several posts but being so new I am not sure where or what to be searching for. I have tried the subsummary totals and I can get a total to print out at each record and then an summary order total on the last record of that order id.

I looked at the invoicing application at http://www.filemakerpros.com/joinprint.zip

but it doesn't seem to fit because I only have the one csv file as my source file.

Currently, I have customer details being repeated in each record so the report isn't practical.

Thanks,

Randal

From what you wrote, its seems as if you can create your report with a simple report with grouped data.

Go to New Layout --> Columnar/List Report --> Report with Grouped Data --> Choose the fields you want on the report --> Choose the field you want to group by (in your case Order Number)

Thanks for the advice. That has worked great.

However, I am now having a problem getting the imported records to be in the correct order.

When I originally built the layout the records I had in the view were ordered by orderid and the report had the subsummary part using orderid. When I ran the report it looked great.

Knowing this data will change everyday I decided to delete all records and import in a new set of records.

However, they don't seem to be ordered correctly and now the report only shows one item per record whereas it was combining them properly before.

I tried sorting them (the imported records) before running the report after they were imported but it still only produces the report with one item per record.

Please advise what I need to do next.

Thanks,

Randal

Deleting & Importing the records should not effect your report in that way. Are you importing the data into the the correct fields?

... and now the report only shows one item per record whereas it was combining them properly before. I tried sorting them (the imported records) before running the report after they were imported but it still only produces the report with one item per record.

It sure sounds like the sort order does not match the part order. You might look again at your leading parts and be sure your sort is in the same field sequence. Run your sort from your report layout as well.

LaRetta :wink2:

Hello,

I think the problem is I was viewing it in the wrong mode. Browse only shows the content per record by using print preview the orders are grouped together by orderid like we wanted.

Now I have a problem with running multiple reports off of the same script. I have filed a question in the script subforum already. Thanks again it has been a big help to me.

Randal