dynamic generation of report fields?

[Guest]

Say I have a table with two fields named "Market" and "Amount", and there
are a number of entries in the table, is there a way to create a report that
will dynamically list the individual Market's and Amounts horizontally?

For instance...table looks like

MARKET AMOUNT
Seattle $100,000
LA $50,000
Seattle $75,000

And the report would loke like ....

MARKET AMOUNT MARKET AMOUNT
Seattle $175,000 LA $50,000

I know this is a wierd one, but have a request from customer.

Thanks,
jj

 

[SA]

JJ:

All you need to do to create the lay out you want is to set the columns
property of the report. File -> page Set up -> columns tab. Set it to
across and then down.