Report Graph not responding to same recordset

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

Guest

I have a report with a report graph whose recordset is the same query that
the report is based on.

I apply a "where condition" variable to the report when I open it and the
main report successfully receives the filter.

Why doesn't the report graph get the filter when it is opened?
 
jonefer said:
I have a report with a report graph whose recordset is the same query
that the report is based on.

I apply a "where condition" variable to the report when I open it and
the main report successfully receives the filter.

Why doesn't the report graph get the filter when it is opened?
Click to expand...

Because the WHERE clause applied to the report has nothing to do with the chart.
 
How then, can I synchronize the report graph's recordsource with the report's
recordsource?
 
Try setting the RowSource on the reports OnOpen or insert this code in
the OnClick of a button on a form:

DoCmd.OpenReport "YourReportName", acViewDesign
Reports!YourReportName!YourGraph.RowSource = "QueryName" or "SQL"
DoCmd.Close acReport, "YourReportName", acSaveYes
DoCmd.OpenReport "YourReportName", acViewPreview

Hope this helps.
 
Back
Top