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