Changing record source of graphs

[lwidjaya]

I need to show graphs based on user's selection. For example, users want to
see graph for data of january 2007 both production shifts and at another time
they only want to see graph for day shift. I can change the record source in
the report, but how do I change the record source of the graph?
I tried this but it didn't work:
Reports!rptDowntimeGraph.Graph1.RecordSource = s
where:
s = sql statement that changes based on the user selection
rptDowntimeGraph = report name
Graph1 = graph name

Thanks in advance,
Lisa

 

[Duane Hookom]

You can use criteria in the Row Source property to filter the results.
Another option is to update the SQL property of your saved query prior to
opening the report.

 

[lwidjaya]

Thanks, Duane. I used the Row Source and it worked!