S
Scott A
I have a report that the user is able to group based on
one of six parameters selected from an option group
(selected on a form). Based on the user's selection, the
report is grouped accordingly.
Unfortunately, the report is roughly 200 pages with all of
the records displayed, so I'm wondering how I could go
about providing the user with an option to filter the
report...
When the report is grouped by one value, I would like to
present them with a list of relevant values (preferably as
a list box, where they could select more than one) that
they can then apply as a filter to the results on the
report. But because I'm giving them six options to group
by in the first place, I have six different lists that
they should be able to choose from!
Should I:
a) use the value stored in the option group to select one
of six filter forms to launch?
b) create one form with six possible list boxes and use
the value in the option group to determine which control
is visible?
Also - I'm pretty clear on what to do if I were giving the
user a combo box to select from (I would only have to
filter on the one value), but I've never used a list box
before and am not quite sure how to pass all of the values
the user selects to the .Filter property of the report and
get it to work correcty.
I would love to hear your ideas!
Thanks,
Scott A
one of six parameters selected from an option group
(selected on a form). Based on the user's selection, the
report is grouped accordingly.
Unfortunately, the report is roughly 200 pages with all of
the records displayed, so I'm wondering how I could go
about providing the user with an option to filter the
report...
When the report is grouped by one value, I would like to
present them with a list of relevant values (preferably as
a list box, where they could select more than one) that
they can then apply as a filter to the results on the
report. But because I'm giving them six options to group
by in the first place, I have six different lists that
they should be able to choose from!
Should I:
a) use the value stored in the option group to select one
of six filter forms to launch?
b) create one form with six possible list boxes and use
the value in the option group to determine which control
is visible?
Also - I'm pretty clear on what to do if I were giving the
user a combo box to select from (I would only have to
filter on the one value), but I've never used a list box
before and am not quite sure how to pass all of the values
the user selects to the .Filter property of the report and
get it to work correcty.
I would love to hear your ideas!
Thanks,
Scott A