Hello
I've been trying to put charts in my reports for awhile now but without much success. I have a query that pulls from the main table the amount of time it took to load a truck based on a range of dates. Once I have the query run, I use that query to build a chart in my report. The problem occurs when I try to change to a different range of dates but my chart only shows the last date range.
As an example:
Run my query with dates 8/1 to 8/15
Place chart into report
Run my query with dates 8/16 to 8/30
Chart still only shows dates 8/1 to 8/15
How do I make my chart data change with how I change my date range? I was able to use a pivot chart that would change dynamically to how my query changes (with the changing date range), but I cannot seem to put a pivot chart into a report. Is there anyway to get my chart to update with how I change my query dates?
I've been trying to put charts in my reports for awhile now but without much success. I have a query that pulls from the main table the amount of time it took to load a truck based on a range of dates. Once I have the query run, I use that query to build a chart in my report. The problem occurs when I try to change to a different range of dates but my chart only shows the last date range.
As an example:
Run my query with dates 8/1 to 8/15
Place chart into report
Run my query with dates 8/16 to 8/30
Chart still only shows dates 8/1 to 8/15
How do I make my chart data change with how I change my date range? I was able to use a pivot chart that would change dynamically to how my query changes (with the changing date range), but I cannot seem to put a pivot chart into a report. Is there anyway to get my chart to update with how I change my query dates?