[AccessD] report grouping on the fly?

Dear all

My colleague Tom and I are working on a reporting tool. The principles are
borrowed from Steve Nyberg's very lovely RFil. (Wih a quite astonishing
amount of fiddle to get 

We are finding that the demand for bespoke report 'templates' (i.e.
pre-created reports that they can then set criteria against) is outstripping
our ability to provide them, because users constantly want different sorting
and grouping. 

Has anyone ever built anything that created group headers & footers on the
fly? I am trying to conceptualize it but it seems like a big task.

Thinking aloud here - I can see that we need to limit the options presented
to the user. They will have little understanding of the data or the
principles of data interrogation. So we will need to determine which
grouping functions to make available and which report fields each function
can apply to.

We will then need to create the appropriate report sections and populate
them with controls, nicely positioned, suitably formatted and containing the
correct data binding / grouping function.

I think positioning them will turn out to be the hardest part; it's such a
visual task when you put total controls on manually.

Any thoughts or advice would be welcome

Cheers

Roz
-------------- next part --------------

The contents of this message and any attachments are the property of Donns Solicitors 
and are intended for the confidential use of the named recipient only.  They may be legally
 privileged and should not be communicated to, or relied upon, by any other party without 
our written consent.  If you are not the addressee, please notify us immediately so that we 
can make arrangements for its return.  You should not show this e-mail to any person or
 take copies as you may be committing a criminal or civil offence for which you may be
 liable.  The statement and opinions expressed in this e-mail message are those of the 
writer, and do not necessarily represent that of Donns Solicitors.  Although any files attached
 to this e-mail will have been checked with virus protection software prior to transmission, 
you should carry out your own virus check before opening any attachment.  
Donns Solicitors does not accept any liability for any damage or loss which may be caused 
by software viruses...