How to print a report with variable number of columns

[larmex]

I need to print a report with a undetermined number of columns, and a list of products as a column header. I already have the D.B., but dont know how to perform the report. The list of products are always the same (they're about 60), and the headers (sales by client) are variable, because these are gropued by sales vendor. The report should see like this

Products Client1 Client2 ... Client_x
-------- ------- ------- --------

The number of clients its variable...
Please help me!

 

[tesar]

Instead direct both header and field clienti
may use function iif(),
or simply create one field
client = str(client1)+str(client2)...
First is better to summary.
Create array aclient(20), fill it code client,
and iif() in header then
(instead client1)
iif(type(aclient[1])= "L","",aclient[1]) ...
Similarly field.
Summary also must respect type field.