Re: Filter chart
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Wed, 1 Nov 2006 11:38:11 -0600
You can "hard-code" parameters from your form controls into your row
sources. Otherwise, you might be able to dynamically build and apply a SQL
statement to the Row Source property of charts in the On Open event of your
report.
--
Duane Hookom
MS Access MVP
"Paco" <paco6945@xxxxxxxxxxxxxxx> wrote in message
news:F5C9C34F-C4B1-4C3E-9B6E-92BA2BC77940@xxxxxxxxxxxxxxxx
I have a form that serves as a printing and filtering menu. There are
numerous reports and charts that all use different filters. For a chart, I
base the chart data rowsource on a query. (e.g., Select x, y from
qryDataSource). I can edit the underlying query to get the results I want,
but I haven't been able to figure out how to apply the filter in code
using
DoCmd.OpenReport .Column(0, varitem), strReportFilter
with .column () being the report name in a list box and strReportFilter
being the WHERE clause.
However, the filter does not limit the records in the underlying query.
Thanks for any suggestions.
Paco
.
- Prev by Date: Re: Report, grouped, to total number of records in that group?
- Next by Date: Re: Report text field: You can't assign a value to this object
- Previous by thread: Report text field: You can't assign a value to this object
- Next by thread: Re: Filter chart
- Index(es):
Relevant Pages
|
