Re: Optional grouping of a report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jedster (Jedster_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 08:03:06 -0800

Alex,

Thanks for your reply, however, I'm not quite sure I fully understand your
solution. It seems that this would only allow me to switch a single grouping
option to any field of my choice.

The problem with this method is that, within my report, I already have a
number of other grouping levels which I wish to retain, and so it is only the
StoreName grouping level that I wish to set as optional. However, I'm not
sure how I might be able to 'optionally' remove all traces of 'StoreName'
from both the display and grouping levels of the report.

Regards,

Jedster

"Alex Dybenko" wrote:

> you can add a "GroupByThis" field to your report source query, aliasing some
> default grouping field, then group report using it. now you can just change
> report recordsource SQL, setting alias GroupByThis to necessary field - and
> report will be grouped accordingly
>
> --
> Alex Dybenko (MVP)
> http://Alex.Dybenko.com
> http://www.PointLtd.com
>
>
>
> "Jedster" <Jedster@discussions.microsoft.com> wrote in message
> news:3B3A359E-AAAF-4C28-8ACE-4D68FFD2081D@microsoft.com...
> > Is there any way I can create a flexible report whereby the grouping for
> > it
> > is optional? I have created a sales report that is sourced from a
> > crosstab
> > query and I now want to provide users with the option (via a form) to
> > group
> > the data on the report by store. I have found a way of amending the
> > query's
> > SQL for this as appropriate, however, I now need a way to firstly amend
> > the
> > grouping options for the report, and then to prevent the report from
> > requesting a parameter value for the 'StoreName' field each time that it
> > is
> > not required.
> >
> > Any help will be much appreciated.
> >
> > Regards,
> >
> > Jedster
>
>
>

Relevant Pages

  • Re: Query Too Complex
    ... what data types are in use at each level? ... > the grouping levels, however this is by no means ideal. ... > Do you know of anything I can do to make this report run with the number ... >> how to run the query. ...
    (microsoft.public.access.reports)
  • Re: Query Too Complex
    ... These IIfstatements that are being summed in the group footers... ... into calculated query fields, and explicitly typecast the results so Access ... That should at least take the burden out of the grouping levels, ... make that easier for the report, and it may also help you identify the part ...
    (microsoft.public.access.reports)
  • Re: 2 problems with access reports
    ... There is nothing that says you can't set your grouping levels to: ... Make sure that your subreport does not have any values in the Link ... > subreport in where I need it on the main report page, ... >>> not see why this isn't sorting correctly. ...
    (microsoft.public.access.reports)
  • Re: Open report with same info as a form
    ... Thanks Duane, I believe this should work just great. ... > You can set the sorting and grouping levels in a report at runtime using ... and in the detail I display the result of a query. ...
    (microsoft.public.access.reports)
  • Re: Open report with same info as a form
    ... You can set the sorting and grouping levels in a report at runtime using ... and in the detail I display the result of a query. ... I realize that the sort settings from ...
    (microsoft.public.access.reports)