Subreport - outputting table column in CSV list

[Antilles]

I have a subreport which is running off my main report page and screwing up.

The subreport is based on a simple select from a table which a numeric column in:
12345
34567
22344
55667
55656
78877
..etc..

But there are hundreds of rows in the table so they run off the report. Is there an easy way to output the contents of this column into my subreport so it comes out as a comma seperated list, e.g.
12345, 34567, 22344, 55667, 55656, 78877

The source of the subreport is currently a simple SELECT column1 FROM table1 which gives a list of everything in the column.

 

[HiTechCoach]

I would suggest using columns in the sub report.

 

[Antilles]

How do I use columns in the subreport (I'm using Access 97 and can't see any obvious way of doing this)?

 

[Antilles]

Never mind - figured it out!

Open up the sub report, click File >> Page Setup. You can set the number of columns here then select the direction of the data.

A most useful feature.

 

[RandiR]

I use biterscripting to process CSV files a lot. There is a good sample script posted at http://www.biterscripting.com/SS_CSV.html . You can automate a lot of table processing using this approach, whether the tables come from a web page or are in local files. All their scripts are open source, you can modify them if necessary, and create your own scritps. http://www.biterscripting.com for free download.

Randi