K
kraymond
I am using a ODBC database. I am trying to create a report that gives a line
graph of water level over time for all devices (up to four) at a particular
site. I made a query that takes the site name from a look-up table, and the
device, water level and date from a related table.
I have tried grouping by site name and putting the chart in the detail
section, but it just prints the graph of all devices (100's of them) over and
over.
In the query I made, I put [Enter Site Name] as a criteria for Site Name to
limit my results. Is this what prevents the chart from working?
Should I use a subreport? I haven't been able to link one correctly to the
main report thus far.
Thanks
graph of water level over time for all devices (up to four) at a particular
site. I made a query that takes the site name from a look-up table, and the
device, water level and date from a related table.
I have tried grouping by site name and putting the chart in the detail
section, but it just prints the graph of all devices (100's of them) over and
over.
In the query I made, I put [Enter Site Name] as a criteria for Site Name to
limit my results. Is this what prevents the chart from working?
Should I use a subreport? I haven't been able to link one correctly to the
main report thus far.
Thanks