Report with variable number of columns

[Catalin]

What's the best way to create a report (tabular) that has variable number of
fields (columns) which is based on the output of a query?

Most often I do not know how many fields will be displayed on the report, so
what I do is create as many textfields as possible and set their visible
property to false. If a column is needed, I just assign it a value and set
visible to true. This makes the report not only big but hard to maintain as
well...

Thanks in advance,
Catalin

 

[Duane Hookom]

I'm not sure there is a more efficient method. You haven't stated why there
are different number of columns. Also, is it imperative to publish the
records in a report or can you send the results to Excel for formatting and
printing?