K
KAitchison
Hi,
I just had a couple of questions about putting charts on reports. I have
developed a rather simple line graph and inserted it on a report. It is
driven by a query that asks for parameter inputs when you open the report.
The problem that i'm having is that when i try to put other things any where
else on report (ie: a box in the header with tree row id maybe species in the
tree row or other information) and have it link to the table or another table
when i preview/print the report it asks me for the parameteres (start date,
end date, what tree row) and then it repeatedly asks me for the same things
.... i dont have the problem when its just the chart on the page.. i've tried
inserting the chart, inserting a subreport with the chart on it .. basing the
txt boxes on the report on different tables...etc..
does anyone have any ideas about this? It would be nice to show other
information and then have the chart on the same report as well... but its
quite a hassle for who ever is printing to have to put in the start date, end
date, and tree row 10 times for the same report...
I'm also wondering if i can get a series to show up on the chart.... so for
example this is what the querry looks like
Date Tree Row #green leaves # yellow leaves
oct 1 1 5 6
oct 1 2 2 4
oct 2 1 6 2
oct 2 2 3 4
when i create the chart i can get it to plot the number of yellow leaves
over a time period for a specific row.. if you dont specify a row then it
sums all of the tree rows together for each data point at a date....
what it would be nice to do is have a line for each tree row, so a
comparison can be made between them on one graph... but i can't seem to get
this to work in access....
this seems like pretty simple stuff but i can not figure out how to get it
to work.. by trying different things or searching online
any ideas would be greatly appreciated..
Krista
I just had a couple of questions about putting charts on reports. I have
developed a rather simple line graph and inserted it on a report. It is
driven by a query that asks for parameter inputs when you open the report.
The problem that i'm having is that when i try to put other things any where
else on report (ie: a box in the header with tree row id maybe species in the
tree row or other information) and have it link to the table or another table
when i preview/print the report it asks me for the parameteres (start date,
end date, what tree row) and then it repeatedly asks me for the same things
.... i dont have the problem when its just the chart on the page.. i've tried
inserting the chart, inserting a subreport with the chart on it .. basing the
txt boxes on the report on different tables...etc..
does anyone have any ideas about this? It would be nice to show other
information and then have the chart on the same report as well... but its
quite a hassle for who ever is printing to have to put in the start date, end
date, and tree row 10 times for the same report...
I'm also wondering if i can get a series to show up on the chart.... so for
example this is what the querry looks like
Date Tree Row #green leaves # yellow leaves
oct 1 1 5 6
oct 1 2 2 4
oct 2 1 6 2
oct 2 2 3 4
when i create the chart i can get it to plot the number of yellow leaves
over a time period for a specific row.. if you dont specify a row then it
sums all of the tree rows together for each data point at a date....
what it would be nice to do is have a line for each tree row, so a
comparison can be made between them on one graph... but i can't seem to get
this to work in access....
this seems like pretty simple stuff but i can not figure out how to get it
to work.. by trying different things or searching online
any ideas would be greatly appreciated..
Krista