R
rob
Hi,
I am creating a report with a line graph. I did not want
to use the default aggregate query for the record source;
I simply wanted to print an X on one axis vs. Y on the
other, for a series of "sites" with each site a separate
page on the report. I did this by changing the record
source to a select query and using the "site ID" as the
linked parent/child field.
The report looks great SOMETIMES, but other times the
report prints ALL of the sites on EACH graph, with each
site as its own series on the same graph. The report
always works the very first time I preview it immediately
after opening the chart itself (not just the report) in
design view).
Another problem- every time I preview the report, I get a
message, "Installing components for Microsoft Graph".
Any insight?
I am creating a report with a line graph. I did not want
to use the default aggregate query for the record source;
I simply wanted to print an X on one axis vs. Y on the
other, for a series of "sites" with each site a separate
page on the report. I did this by changing the record
source to a select query and using the "site ID" as the
linked parent/child field.
The report looks great SOMETIMES, but other times the
report prints ALL of the sites on EACH graph, with each
site as its own series on the same graph. The report
always works the very first time I preview it immediately
after opening the chart itself (not just the report) in
design view).
Another problem- every time I preview the report, I get a
message, "Installing components for Microsoft Graph".
Any insight?