I have a report with several fields - job #, invoice #, invoice amount, cost type, supplier and amount.
The cost type field is one of these values:
1. Color separation
2. copy writing
6. Studio Time
The supplier, cost type and amount are from the same table. SO there for each Supplier, there is a Cost Type and amount.
The user requires to have 6 columns on the report for each cost type. Under each colum should be the appropriate cost amount i.e. for color separation there should be an amount.
How can I sort the fields or rather data on the report into these columns?
p.s. Someone told me that my only option is to use 6 subreports. Is this true?