Data to Array Manipulation

[Crimpage]

Hi All,

I'm making a report for work, and what we have is a table that has these fields we need to use:

Table:
- Office
- Broker Name
- Financier
- Client
- About 5 info columns

What I need to do, is turn that into an array that looks like:

Array (
- Office
- Broker Name
- Financier
-Client 1
- Info columns
- Client2
- Info columns


We need to do this so that we can break up the pages so that each broker has their own page etc.

Thanks for your help.

Crimpage.

[AndyB]

Table? Do you mean database table. If so, why not SELECT data with a WHERE broker=something type of SQL query?

[Crimpage]

Sorry, I probably should have worded it better.

Yes the info will be coming from a database. I have no problems with the query and if I don't need to create an array like this then that could be even better.

Basically, I need the report to be grouped together by the office, then broker, then financier.

So the report would look like:

Page1:
Office: Melbourne
Broker: Broker 1
Financier: Financier 1
Client 1 & Info
Client 2 & Info
Client 3 & Info
Financier: Financier 2
Client 4 & Info
Client 5 & Info

Broker: Broker 2
Financier: Financier 1 (same as number 1 above)
Client 1 & Info
Client 2 & Info
Client 3 & Info

Office: Sydney
and so on.

Thanks,

Crimpage.