using WhereCondition:= on charts and graphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have several graphs/charts, whatever you want to call them, that I would
like to use listboxes to filter parameters for. I've used Allen Browne's
multi-select listboxes before, and can successfully build the filter for the
report. The question I have is about how to implement this filter when the
report is a graph.

Even though debug.print strFilter says "[PersonID] IN ("Adam", "Eve")
the chart still prints with all people.

The report source is "qryReportbyPerson"
The chart is in the header of the report, and properties are:
Name: OLEUnbound0
OLE Class: Microsoft Graph Chart
Row Source Type: Table/Query
Row Source: TRANSFORM Count(qryReportbyPerson.PDetailsID) AS
CountOfPDetailsID SELECT qryReportbyPerson.PersonID FROM qryReportbyPerson
GROUP BY qryReportbyPerson.PersonID PIVOT qryReportbyPerson.GroupName;

It will not let me link child fields because "Can't build a link between
unbound forms."

Any ideas? *Crossing my fingers*

Thanks!!!!!!
 
One method would be to use DAO code to change the SQL property of
"qryReportbyPerson" prior to opening the report. I expect Allen's sample
builds at least the where condition that would be part of the SQL.
 
Back
Top