josephwalter
Programmer
I have a Data Access Page (DAP) that reports the results of our manufacturing By Crew.
Here's a short example:
Date Product Crew Results
3/1/04 xyz A 50
3/2/04 xyz A 51
3/4/04 xyz A 49
3/5/04 xyz B 52
3/6/04 xyz B 53
In addition to showing the data, I put a line graph on the page (to give users a visual of the results). The DAP and the graph get their data from a SQL Server Stored Procedure. The data is grouped by Product and by Crew, and the chart is in the Product Header.
But my chart only displays the values from the last Crew. When I set all the records to the same Crew, the chart display all the values... strange.
Has anyone seen this behavior before? What am I overlooking?
I'd be happy to post more details - I just didn't want my message to get too long. Thanks for looking!
Here's a short example:
Date Product Crew Results
3/1/04 xyz A 50
3/2/04 xyz A 51
3/4/04 xyz A 49
3/5/04 xyz B 52
3/6/04 xyz B 53
In addition to showing the data, I put a line graph on the page (to give users a visual of the results). The DAP and the graph get their data from a SQL Server Stored Procedure. The data is grouped by Product and by Crew, and the chart is in the Product Header.
But my chart only displays the values from the last Crew. When I set all the records to the same Crew, the chart display all the values... strange.
Has anyone seen this behavior before? What am I overlooking?
I'd be happy to post more details - I just didn't want my message to get too long. Thanks for looking!
