Creating Reports on the Fly at runtime 1

[StuckInTheMiddle]

Hi,

I've created a VBA form which allows the user to select from checkbox which fields from various tables they want.

My VBA then creates a query and runs it to retrieve the fields and this works great, however I want to be able to 'format' the output into a report.

The problem i have is when creating the report that I don't know which fields the user is going to select at design time. Is there some way to create a report at <i>runtime</i> in much the same way i did the query?

 

[MichaelRed]

Yes, ... but ... but ... but ...,


There are a LOT of issues to resolve: control positioning, Ordering, Grouping, Control Size, page properties (Boraders, orientation, ...), Special effects, ...


Altogether, there is a lot more than any be the most expert of users are going to even be close to capable of. And -THOSE users would find it easier to just be able to generate their own (&quot;Custom&quot reports - so the real question is really &quot;Why&quot;, not &quot;If&quot; or even &quot;HOW&quot;, just plain old &quot;WHY&quot;?

On the other hand, if you have a lot of reports which are BAASICALLY the same, and the goal is to provide small customizations, this cha be done reasonably well by setting up some reports where the USER can select MULTIPLE critria and ranges, to present the 'same old data' in custom appearances.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over