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.

 

[SOS]

What is the row source for your chart? It would need to have criteria which refers to the group.

 

[mwinters13]

I used the chart wizard in order to grab the necessary information and this is what the wizard generated for my row source

TRANSFORM Sum(CharacterizationReportQuery.Fails) AS SumOfFails
SELECT CharacterizationReportQuery.VDD
FROM CharacterizationReportQuery
GROUP BY CharacterizationReportQuery.VDD
ORDER BY CharacterizationReportQuery.VDD, CharacterizationReportQuery.Vzip DESC
PIVOT CharacterizationReportQuery.Vzip;

Now that you pointed that out, this row-source does not include "temperature" which would explain why it doesn't change with each grouping.

Any suggestions on what to add to make it so? Thank you for your response!

 

[SOS]

TRANSFORM Sum(CharacterizationReportQuery.Fails) AS SumOfFails
Assuming that the field is in that query and assuming that your report group is by temperature

SELECT CharacterizationReportQuery.VDD
FROM CharacterizationReportQuery
WHERE CharacterizationReportQuery.temperature = Me!temperature
GROUP BY CharacterizationReportQuery.VDD
ORDER BY CharacterizationReportQuery.VDD, CharacterizationReportQuery.Vzip DESC
PIVOT CharacterizationReportQuery.Vzip;

 

[mwinters13]

Forgive me asking, I am new to access. The SQL statement you gave me I believe will work, however, what is being represented by the "Me!Temperature" statement clause?

I entered it and the report threw an error saying it did not recognize the Me!

 

[SOS]

Forgive me asking, I am new to access. The SQL statement you gave me I believe will work, however, what is being represented by the "Me!Temperature" statement clause?

I entered it and the report threw an error saying it did not recognize the Me!

Oops, forgot we weren't in VBA (Me in VBA refers to the current class object, which would be the report). Just change it to use

WHERE CharacterizationReportQuery.temperature = [temperature]

instead

 

[mwinters13]

Unfortunately, it still did not update the graph. It still shows the correct data for the first temp set, but then just uses the same graph for each other set.

Is there perhaps something in the VBA that I am missing? Maybe adding a Requery or Repaint command somewhere?

 

[SOS]

Can you upload a copy of the database (with fake data) so we can take a look? If you want to do so, you would need to

1. Run COMPACT AND REPAIR
2. From Windows Explorer, right click on the file and select SEND TO > COMPRESSED FOLDER.
3. Then you can upload it here (as long as the final zipped file is 2MB or less. The key is to run the Compact and Repair utility that Access has first to get it as small as possible.

 

[mwinters13]

I've attached a copy of the DB. Just be sure to enable macros so that the form runs properly...

To get it to work properly just open the form and adjust the values ( or leave them the same ). To really see an accurate data-set, set the array = 1 and the block range from 0 to 0. Then just open the report from there.

Thanks

 

[JHB]

You have to run the report in "Print preview" and not in "Report view"

 

[mwinters13]

You have to run the report in "Print preview" and not in "Report view"

JHB, That still did not work, opening the graph in "print Preview" still shows the same problem, and the same graph is just cloned throughout the report

 

[JHB]

Sorry - I have forgotten to mention you have to rename the control in the report which shows the temperature to "Temperature".
Then you also have to link the report and the graph together by the "Link Master Fields" and "Link Child Fields" property. Link them together by "Temperature"
I've attached the database and a picture which shows the graph by temperature of 25.

 

[mwinters13]

Sorry - I have forgotten to mention you have to rename the control in the report which shows the temperature to "Temperature".
Then you also have to link the report and the graph together by the "Link Master Fields" and "Link Child Fields" property. Link them together by "Temperature"
I've attached the database and a picture which shows the graph by temperature of 25.

Thank you so much! Finally works, can't thank you enough

 

[JHB]

You're welcome - good you got it to work.