Charts disappear from Report

[kevvo]

Hello,

I am building an access report based on an existing one. It features a 'dashboard' of charts grouped under a header, we'll call it "category", which is also the child and master link field for all of the reports.

The problem has occurred when I have added a new chart, created a rowsource (which shows the right data for the chart) and then I preview the report. All of the charts then appear blank!

You'll probably need to ask a load of questions to work out what I've done to cause this, but are there any known issues which immediately spring to mind?

Thanks
Kevvo

 

[dhookom]

I assume you have the correct values in the Link Master/Child properties of the chart controls? This would also assume the report is bound and returns the correct value for the linking.

ACGSoft has some chart tips at

http://www.groupacg.com/.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kevvo]

I've narrowed it down now to the point that I can see the graphs only dissapear when I remove a particular subreport. The graphs all run on a sql query unconnected to this subreport, so I'm a little confused as to why this only happens when I remove the subreport.

 

[dhookom]

I made some comments and suggested a resource on the web. Did you try any of this or have any reply regarding the comments?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kevvo]

Yes thanks, I had a look, but they didn't seem to answer the query I have.

The base query on which the report is built looks like this:

SELECT PLANACT.*, contractsref.description, specref.specGroup, specref.careGroup
FROM (PLANACT LEFT JOIN contractsref ON PLANACT.contract = contractsref.contract) LEFT JOIN specref ON PLANACT.spec = specref.code
WHERE (((PLANACT.report)="RP"));


Each of the charts in the report (I am not including any tabular data at all), is based on a similar query:

SELECT monthref.monthname, Sum(PLANACT.IP) AS IPact, Sum(PLANACT.EM) AS EMact, Sum(PLANACT.DC) AS DCact, Sum(PLANACT.PIP) AS IPplan, Sum(PLANACT.PEM) AS EMplan, Sum(PLANACT.PDC) AS DCplan
FROM (PLANACT INNER JOIN monthref ON PLANACT.mon = monthref.monthnum) INNER JOIN specref ON PLANACT.spec = specref.code
GROUP BY monthref.monthname, PLANACT.yearmon
ORDER BY PLANACT.yearmon;

In the link child fields and link master fields sections, I have detailed the 'SpecGroup' field.

However when I try to do the builder on this, it says "can't build a link between unbound forms". And then when I open the report, they are blank.

The bizarre thing is that when i had another subreport in this one, the charts appeared...

I hope this is a bit less vague for you, sorry for the rather unclear first question.

 

[dhookom]

I don't see the field "SpecGroup" in the Row Source of your charts. You don't need to use the builder to enter the link master/child properties.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]