Saving Records to multiple Excel worksheets

[Nestor]

Hi All

I have a list of 4000 records for multiple customers (around 40 customers). My list consist of CustomerNumber, invoice number, invoice date, dollar ammount.

What i want to do is be able to run a report to this list and have my script save every customer to one worksheet. So in 1 worksheet i want to see all entries from the same customer, and so on for all my customers.

Is this possible? IF not can it be possible to create one excel sheet for every customer.

I want to prevent from doing a find mode for every customer and save to excel.

Thanks

[bcooney]

Do you have a Customer table? If so, just loop thru Customers, gtrr, and export found set. Back to next Customer.

[Nestor]

I don't have a customer table.

All i have is 1 table with all the fields. (Im actually pulling all this info from our Accounting System-MAS90)

Do you tink i have to create a customers table?

i guess the only issue is that i have to keep that table updated.

Do you have a Customer table? If so, just loop thru Customers, gtrr, and export found set. Back to next Customer.

[bcooney]

No, it's easier to do if you have a Customer table.

Without a parent table, you will need another approach.

I'm thinking sort by CustomerID, then loop. Capture CustomerID in a $var. gtrr new window using a self-join and then export. Close window, next record. If $var=customerID, then go to next, otherwise, you're on a new customer, so gtrr export.

Is that at all understandable?

[Nestor]

It Makes perfect sense..

I'll give it a try.

Thanks.. :