Tiling Fields in Data Report Designer.

[Dr_Evil]

I am working on a new data report at the moment. Does anyone know if it is possible to tile the fields on a data report? Ex.


Not Tiled.

Product Part Number
Container# Container Weight
Sample # Date

Sieve # % ON % THRU
60 .85 99.15
100 1.0 98.15
180 5.0 93.15
220 20.0 73.15
325 30.0 43.15


Product Part Number
Container# Container Weight
Sample # Date

Sieve # % ON % THRU
60 1.85 98.15
100 1.0 97.15
180 5.0 92.15
220 20.0 72.15
325 30.0 42.15
__________________________________________________________

Tiled

Product Part# Product Part#
Container# Weight Container# Weight
Sample# Date Sample# Date

Sieve # % ON % THRU Sieve # % ON % THRU
60 .85 99.15 60 1 99
100 1.0 98.15 100 5 94
180 5.0 93.15 180 15 79
220 20.0 73.15 220 30 49
325 30.0 43.15 325 42 7


Product Part# Product Part#
Container# Weight Container# Weight
Sample# Date Sample# Date

Sieve # % ON % THRU Sieve # % ON % THRU
60 1.85 98.15 60 2 98
100 1.0 97.15 100 5 93
180 5.0 92.15 180 15 78
220 20.0 72.15 220 30 48
325 30.0 42.15 325 42 6


I need to do this to cut down on the amount of wasted paper, each sheet is mostly blank for the exception of the left column of information. The Sieve info must be in this form for the customer.
Thanks in advance.

[Gary.Lowe]

Dr_Evil

In crystal reports there is a property of the page that allows you to specifiy how many columns you want to use on the page.

I'm not sure if the same exists for the data report but as it exists on Access 97 and the data report seems a similar construction it may there somewhere.

I have found though that the data report on vb is quite limiting as to what you can do with compared to crystal reports.

Gazza