Report Graph not responding to same recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jonefer - 12 Jan 2005 02:47 GMT

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?

Reply to this Message

Rick Brandt - 12 Jan 2005 03:29 GMT

> I have a report with a report graph whose recordset is the same query
> that the report is based on.
[quoted text clipped - 3 lines]
>
> Why doesn't the report graph get the filter when it is opened?

Because the WHERE clause applied to the report has nothing to do with the chart.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

jonefer - 18 Jan 2005 19:21 GMT

How then, can I synchronize the report graph's recordsource with the report's
recordsource?

> > I have a report with a report graph whose recordset is the same query
> > that the report is based on.
[quoted text clipped - 5 lines]
>
> Because the WHERE clause applied to the report has nothing to do with the chart.

Reply to this Message

Penguin - 19 Jan 2005 06:28 GMT

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.

>How then, can I synchronize the report graph's recordsource with the report's
>recordsource?
[quoted text clipped - 8 lines]
>>
>> Because the WHERE clause applied to the report has nothing to do with the chart.

Reply to this Message