Pie Chart not displaying as subreport (1 Viewer)

Local time
Today, 06:11
Joined
Feb 2, 2020
Messages
45
I have a Pie Chart in a report that works just fine. As soon as I place that report with the chart into another report as a subreport, it no longer displays the chart.
I tried look at master/child links, which to me seem correct. Record source for the Pie Chart is a query. I have also tried to requery the chart using the On Format event on the report.
I would appreciate some help getting this one solved.

Thanks
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
Have you tried printing the report or switch the views (Layout, print preview, etc)?
 
Local time
Today, 06:11
Joined
Feb 2, 2020
Messages
45
Have you tried printing the report or switch the views (Layout, print preview, etc)?
I did not until you sent your reply.
Printing the report where the Pie Chart displays, works fine. Printing the report where it is in-bedded as a subreport does not work. No error messages are displayed
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
Well that is SOME good news. Did you try the Print Preview?
 
Local time
Today, 06:11
Joined
Feb 2, 2020
Messages
45
Well that is SOME good news. Did you try the Print Preview?
Yes Sir. Same results.
On the standalone report where it displays with no problem, I don't seem to have any issues. As soon as that report though is inbedded as a subreport in another report, it no longer displays. It is no longer visible in PrintPreview and it does not print out.
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
Can you provide a copy of your DB so we can have a look-see?
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
I see two reports (ProjectCosts & ProjectCostsSummary) but neither of them have the chart you mentioned...
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
Strange...I get nothing but blank space. Even in design view, I show nothing. What version of Access are you using?
 

jdraw

Super Moderator
Staff member
Local time
Today, 06:11
Joined
Jan 23, 2006
Messages
13,102
I'm seeing the chart on report (using O365)
ProjectWithChart.PNG
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
Well color me confused! Jack, I officially hand this over to you!
 

jdraw

Super Moderator
Staff member
Local time
Today, 06:11
Joined
Jan 23, 2006
Messages
13,102
NG,
Not sure what the issue can be???
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
No idea. I will try this when I get home...this US Gov computer at work can be wonky with all the WIN-10 security and Office STIGs in place.
 

NauticalGent

CopyPaster of the First Order
Local time
Today, 12:11
Joined
Apr 27, 2015
Messages
2,854
I'm running O365, 64 bit at home and everything displays fine. Go figure...
 
Local time
Today, 03:11
Joined
May 22, 2010
Messages
2,086
I would suggest recreating the object in a fresh report, I had success doing that. The query the OP is using is complex with many joins.
Code:
SELECT Sum(tblInvoices.TotalCharge) AS SumOfTotalCharge, tblServiceType.Category, tblProjectOwners.[Project Owner Name], tblProjects.ID, tblProjects.[Projet Name]
FROM ((tblInvoices LEFT JOIN tblServiceType ON tblInvoices.[Activity Type Name] = tblServiceType.ID) LEFT JOIN tblProjects ON tblInvoices.[Project Name] = tblProjects.ID) LEFT JOIN tblProjectOwners ON tblInvoices.[Project Owner Name] = tblProjectOwners.ID
GROUP BY tblServiceType.Category, tblProjectOwners.[Project Owner Name], tblProjects.ID, tblProjects.[Projet Name];
 
Local time
Today, 06:11
Joined
Feb 2, 2020
Messages
45
I would suggest recreating the object in a fresh report, I had success doing that. The query the OP is using is complex with many joins.
Code:
SELECT Sum(tblInvoices.TotalCharge) AS SumOfTotalCharge, tblServiceType.Category, tblProjectOwners.[Project Owner Name], tblProjects.ID, tblProjects.[Projet Name]
FROM ((tblInvoices LEFT JOIN tblServiceType ON tblInvoices.[Activity Type Name] = tblServiceType.ID) LEFT JOIN tblProjects ON tblInvoices.[Project Name] = tblProjects.ID) LEFT JOIN tblProjectOwners ON tblInvoices.[Project Owner Name] = tblProjectOwners.ID
GROUP BY tblServiceType.Category, tblProjectOwners.[Project Owner Name], tblProjects.ID, tblProjects.[Projet Name];
I really appreciate everyone looking at this. I did create a new report but was not successful in seeing the report. Would you mind sharing yours that you created? Thanks
 
Local time
Today, 03:11
Joined
May 22, 2010
Messages
2,086
Michael, I would suggest you try and create the chart sperate then add the other objects. I was not very successful integrating the charts with your objects.


Test Report.PNG


Test Report2.PNG
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom