Report graph not updating with each new group

[mwinters13]

Hello all,

I am encountering a problem with getting my graphs to update.

I currently have a report that generates information based upon a query. The report is broken down into 3 subgroups (Temperature --> Vzip --> VDD). The information within each subgroup seems to be correct as the report cascades through each grouping, however the graph does not update with the new information and instead just copies a clone of itself throughout each Temperature group in the report.

That being said, the first graph that is generated is correct for that group (Temp: -55)... but the report simply copies that graph into the next temperature categories.

From what I've seen I believe that this is probably a very easy fix/solution but I cannot seem to figure it out.



I've attached a .pdf of a report generated to visually show what I am referring to, ** notice it replicates the same graph for each group **

Any suggestions?

Thank you.

[June7]

I analyse graph issues best with the db. If you want to provide db, follow instructions at bottom of my post.

What section is the graph in? How is the graph related to the report record - Master/Child links properties or filter criteria in the graph RowSource?

I had a similar issue and resolved by putting the graph in group footer. The graph data is filtered by reference to ID field on report:

SELECT [DropNum], CumulativePenMM FROM [dcpfiledata] WHERE [HoleNum] = [Hole];

[mwinters13]

Thank you for your response, I found one thing that I thought might be wrong in the RowSource, before I did not have a WHERE clause, I've since added one so that it now reads "WHERE CharacterizationReportQuery.Temperature = [Temperature]" however the graph still remains the same throughout the iterations.

I've attached a copy of the DB for analysis, thank you in advance for helping out, it is really appreciated.

PS - I'm sure you already know this, but be sure to Enable Macros in order for the Form to run correctly. To see the error first hand first bring up the form and change some values around (set array = 1, and block range 0-0 for best view) and then open up the report

[June7]

I've never had to build graph with CROSSTAB query. Applying filter criteria in CROSSTAB is different than other queries. Review http://allenbrowne.com/ser-67.html#Param

I did not try to create parameterized CROSSTAB. Here's how I got graph to work:

1. named the Temperature textbox to tbxTemp

2. built another query
SELECT CharacterizationDataBlock.Temperature, CharacterizationDataBlock.Vzip, CharacterizationDataBlock.VDD, Sum(IIf([Vzip]=0,[Fails],Null)) AS Vzip0Fails, Sum(IIf([Vzip]=1,[Fails],Null)) AS Vzip1Fails, Sum(IIf([Vzip]=2,[Fails],Null)) AS Vzip2Fails, Sum(IIf([Vzip]=3,[Fails],Null)) AS Vzip3Fails, Sum(IIf([Vzip]=4,[Fails],Null)) AS Vzip4Fails
FROM CharacterizationDataBlock
WHERE (((CharacterizationDataBlock.LotID)=Get_Global("Pr ojectID_VAR")) AND ((CharacterizationDataBlock.ChipID)>=Get_Global("C HIPMIN_VAR") And (CharacterizationDataBlock.ChipID)<=Get_Global("CH IPMAX_VAR")) AND ((CharacterizationDataBlock.Array)=Get_Global("Arr ay_VAR")) AND ((CharacterizationDataBlock.Block)>=Get_Global("BL OCKMIN_VAR") And (CharacterizationDataBlock.Block)<=Get_Global("BLO CKMAX_VAR")))
GROUP BY CharacterizationDataBlock.Temperature, CharacterizationDataBlock.Vzip, CharacterizationDataBlock.VDD
HAVING (((CharacterizationDataBlock.Temperature)>=Get_Glo bal("TEMPMIN_VAR") And (CharacterizationDataBlock.Temperature)<=Get_Globa l("TEMPMAX_VAR")) AND ((CharacterizationDataBlock.VDD)>=Get_Global("VDDM IN_VAR") And (CharacterizationDataBlock.VDD)<=Get_Global("VDDMA X_VAR")));

If you copy/paste the above, be aware there are spaces thrown in by the forum - I found 11.

3. change graph RowSource to pull from the above query
SELECT VDD, Vzip0Fails, Vzip1Fails, Vzip2Fails, Vzip3Fails, Vzip4Fails FROM Query1 WHERE Temperature=tbxTemp;

I avoid global variables. I would just have query reference the controls on form.

[mwinters13]

June7,

Thank you for that solution, The graph is now updating correctly with the right information.

However I still have one issue with how it is presented. Is there anyway to NOT have the x-axis split up according to each vzip? Meaning is it possible to have the whole x-axis show VDD 1.4-1.9 across the whole way that way you can compare the curves of each Vzip, because that is what we are attempting to show.

As of now, the x-axis cycles through all the VDD's of VZIP 0, then Vzip 1, etc... I need them all to be on one continuous line on the x-axis so that the curves plot all the way across the graph like in the original graph. Is this possible?

I've attached the updated DB to show your changes from the last post.

[June7]

Oops, sorry.

4. Change the graph to a scatter with data points connected by smoothed lines.

[mwinters13]

Thank you!

I appreciate your help. Your solution solved the problem with this particular project.

But, the reason I was using the CrossTab Query before was so that I could create an automated report generator in access for our diffferent project. Your solution will work for this current project (with Vzips 0-4) however it will not work when I come to another project with different VZips. I would then have to manually enter all the IF statements for each Vzip value.

I know you said before that you didn't use crosstabs before but do you know why the original wouldnt work in the format that it was in? or do you know of something that could point me in the right direction?

Again, Thank you for all of your help!

[June7]

The Allen Browne link I provided earlier in post 4 is the only clue I can offer.

I went back and tried to create parameterized crosstab. The data still did not update for each temperature group. Solve that mystery and should have a dynamic graph.