[AccessD] report grouping on the fly?

Roz:

On many of the reports in the manufacturing app I give the users three 
levels of sorting on fields which they select from a combo box.  The report 
is set up with three groupings defaulted to some low level field like part 
number.  Then, in the Open event of the report I set the grouping field:

Me.GroupLevel(0).ControlSource = 
Forms!frmSupplySideReport!cboSort1.Column(0)
Me.GroupLevel(1).ControlSource = 
Forms!frmSupplySideReport!cboSort2.Column(0)
Me.GroupLevel(2).ControlSource = 
Forms!frmSupplySideReport!cboSort3.Column(0)

HTH

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334


----- Original Message ----- 
From: "Roz Clarke" <roz.clarke at donnslaw.co.uk>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, March 08, 2005 9:03 AM
Subject: [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
>


--------------------------------------------------------------------------------


>
> 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...
>


--------------------------------------------------------------------------------


> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>