Pie Chart not displaying as subreport (1 Viewer)

[Michael Barkemeyer]

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]

Have you tried printing the report or switch the views (Layout, print preview, etc)?

 

[Michael Barkemeyer]

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]

Well that is SOME good news. Did you try the Print Preview?

 

[Michael Barkemeyer]

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]

Can you provide a copy of your DB so we can have a look-see?

 

[Michael Barkemeyer]

Can you provide a copy of your DB so we can have a look-see?

My apologies for the delay. I had to re-create in new DB to be able to send.
Thank you for taking a look.

 

[NauticalGent]

I see two reports (ProjectCosts & ProjectCostsSummary) but neither of them have the chart you mentioned...

 

[Michael Barkemeyer]

I see two reports (ProjectCosts & ProjectCostsSummary) but neither of them have the chart you mentioned...

Thats very interesting. I opened back up what I sent and can see the pie chart in ProjectCostSummary

 

[NauticalGent]

Strange...I get nothing but blank space. Even in design view, I show nothing. What version of Access are you using?

 

[jdraw]

I'm seeing the chart on report (using O365)

 

[NauticalGent]

Well color me confused! Jack, I officially hand this over to you!

 

[jdraw]

NG,
Not sure what the issue can be???

 

[NauticalGent]

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.

 

[AccessBlaster]

I can't see what Jack displays either, Access Pro 2016 32bit

 

[NauticalGent]

I'm running O365, 64 bit at home and everything displays fine. Go figure...

 

[AccessBlaster]

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.

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];

 

[Michael Barkemeyer]

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.

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

 

[AccessBlaster]

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.