thatlemhome
Registered User.
- Local time
- Today, 14:44
- Joined
- Mar 31, 2009
- Messages
- 26
Is anyone aware of a bug in 2007 which is related to forcing a user to answer a date range twice when pulling a report with a chart.
I have a query that has a between date range defined. It works fine. I then built a report which includes a chart. Which pulls fine as long as the date range is NOT defined in the query.
But once I add the date range between statement to the query, the report asks for it twice when I try to run it, and again for any subsequent page in the report with a chart. If I run in view mode, it appears that the report is asking for the date range (I can see the report start to build after the first date) and then again to build the chart.
At some level it makes sense as both the report and chart reference the same query, but I've built prior versions in 2003 and even converted to 2007 without incident. Even have 83 page reports with a chart on each page and only have to enter the range once.
Any Ideas?????? Have been at it for hours, and I'm stumped.
I have a query that has a between date range defined. It works fine. I then built a report which includes a chart. Which pulls fine as long as the date range is NOT defined in the query.
But once I add the date range between statement to the query, the report asks for it twice when I try to run it, and again for any subsequent page in the report with a chart. If I run in view mode, it appears that the report is asking for the date range (I can see the report start to build after the first date) and then again to build the chart.
At some level it makes sense as both the report and chart reference the same query, but I've built prior versions in 2003 and even converted to 2007 without incident. Even have 83 page reports with a chart on each page and only have to enter the range once.
Any Ideas?????? Have been at it for hours, and I'm stumped.
