Dynamic Reports

[Gastank]

All the references I've read concerning "Dynamic" Reports show, by using crosstab queries, how to control columns of data. Is it possible to create dynamic rows. The reason I ask is that I am trying to produce a report detailing records of product returns, showing quantity and type of product etc.
Whilst most records will involve 1 or 2 items I could have upto 8 different items per return. Trying to fit 16 columns (8 x qty - 8 x product) plus an adittional 4 or 5 fields per record exceeds the report width even in landscape mode.
Any help would be greatly appreciated

 

[WayneRyan]

Gastank,

Why don't you ask for something hard ...

Just kidding.

The only way that I can see is that you can (in design view)
make the "worst case" report. Full width, narrow fields.
Preferably with your static data either left-margin or
right-margin.

Then in the OnFormat event (for record 1) you will know how
many columns you will need. Set the rightmost n columns
to .visible = False, then you can move the other controls
and resize them.

You will have to experiment with the math.

This is non-trivial, but sometimes you just gotta do it ...

I'll be interested to see if anyone comes up with anything
short of putting it into Excel.

Wayne

 

[Gastank]

Wayne,

thanks for the reply, however I'd like to keep the process within Access if I can rather than using Excel for the reports. I guess I'll just have to keep "experimenting"

Frank