Graph Rowsource (Access2k)

Topic

New Reply

Can the rowsource for a graph be set in the OnOpen event? I’ve done this with regular reports but couldn’t see where to do it for a graph.
I’m trying to cut down on the ammount of graphs I need to create by just changing the rowsource and using a static graph.

Reply | Quote

Replies

Reports are different from forms in this respect. You can’t set the row source of a chart on a report in the On Open event of the report, ar at any later moment while the report is open in print preview. The only way to do it is to open the report in design view, change the row source of the chart, then switch to print preview. Details in ACC2000: How to Set the RowSource Property of a Report Graph Dynamically.

Note: if you have multiple users, you must give each user a private frontend database, for you can’t change the design of database objects when multiple users have the database open.

If possible, see if you can use a parameter query as row source. This allows you to display different data sets without changing the design of database objects.

Reply | Quote

Thanks Hans, I’ll experiment with that

Reply | Quote

Thanks Hans, I’ll experiment with that

Reply | Quote

Reports are different from forms in this respect. You can’t set the row source of a chart on a report in the On Open event of the report, ar at any later moment while the report is open in print preview. The only way to do it is to open the report in design view, change the row source of the chart, then switch to print preview. Details in ACC2000: How to Set the RowSource Property of a Report Graph Dynamically.

Note: if you have multiple users, you must give each user a private frontend database, for you can’t change the design of database objects when multiple users have the database open.

If possible, see if you can use a parameter query as row source. This allows you to display different data sets without changing the design of database objects.

Reply | Quote