Unwanted Duplicate Graph in Report

[AMEDMERRT1]

Created Report using chart wizard based on query that returns quarterly value. 1 record [value] for each quarter. The data in the graph is correct for each quarter. Problem is I get a full graph (Exact Duplicate containing all completed quarters)for every quarter/record the query returns. Up to 4 of course. Is there a way to limit to just one full graph [All completed Quarters] per report.

[TheSmileyCoder]

I simply can't understand enough of your meaning to make sense of it. Could you try posting a screenshot of your report in design view, so that I can get a better understanding?

[AMEDMERRT1]

Pdf ok?

2012 IC-Totals.pdf]

Thanks for your time, expertise and concern in assisting me with this problem. Please view the attached PDF file. It contains the report exactly as it prints. Hope this will help you help me.

[AMEDMERRT1]

Here's a PDF with a Design View

2012 IC-TotalsDesignView.pdf

Here's the report as it appears in Design View. Again thanks for your help.

[AMEDMERRT1]

Would a snapshot of the Query the report is based on help?

[zmbd]

Would a snapshot of the Query the report is based on help?

It's not going to hurt to have the query.
Open the query in design mode
Change the view to SQL
Copy and paste the text that is shown in the SQL view into the reply box here.
In the reply box, select the entire SQL and then click the <CODE/> button in the formatting bar above (or manually place [CODE] at the start and [/CODE]at the end of the SQL text).

It would also be helpfull to know which version of the Access you're using (2003?).

[AMEDMERRT1]

The Query Driving the Report as requested.

Query DesignView.pdf
-

SELECT DISTINCTROW 
   [PT-IC-DATA Query].[DateServiced By Quarter], 
   Sum([PT-IC-DATA Query].CountOfInfectionType) 
    AS [Sum Of CountOfInfectionType], 
   Avg([PT-IC-DATA Query].TotalClients) 
    AS AvgOfTotalClients, 
  Sum([PT-IC-DATA Query].[CountOfPT-ICDATA#]) 
    AS [SumOfCountOfPT-ICDATA#]
FROM [PT-IC-DATA Query]
GROUP BY 
   [PT-IC-DATA Query].[DateServiced By Quarter]
HAVING 
  ((([PT-IC-DATA Query].[DateServiced By Quarter])
     Like "Q* 2012"));

You asked for ACCESS Version. It's MS OFFICE-2000. Also find attached a PDF of the Query Snapshot with all property windows on view.

[AMEDMERRT1]

Is there anything else I can provide you with that will assist you in resolving the issue I am having? Just lemme know. Again thanks for your time and effort.

[zmbd]

I've been trying to duplicate this in V2010 without much success unless I set the report to multiple records per page...
Please be patient. We're all unpaid volunteers here and work on these things between our paid jobs.

[AMEDMERRT1]

I knew that and appreciate your efforts all the more because of it. I do free PC work all the time too. I often build systems for poor kids who wouldn't know the pure joy of Computing without the Freebe I can provide. I get the PC's used from small businesses I've done free work for. Setting up small networks, virus repair and relational database automation. They give me older PC's and other stuff. I fix'm up, give'm cheap boosts and give'm away. It's a hobby and I am self taught. I am in HealthCare and that's what I was educated towards. Both are very rewarding. In closing "Please, take your time, enjoy your efforts. I'm in no rush and have nothing but admiration for the service you guys provide."

[zmbd]

Duh.... why is it the simple things that I stub my toe on...

I was creating the graph on an unbound report... when bound to a record source the report will create the multiple graphs as shown if the graph control is in the detail section - one for each record in the record set (obvious to me now that I thought about it... came to me while working on a problem for TheSmileyCoder)

Two solutions:
- If you do not have any other bound controls on the report then remove the record source from the report
- Move the Graph to the page footer/header to have the graph print once at the bottom of each page in the report
- - Move the Graph to the report footer/header to have the graph print either at the end of the report or at the beginning of the report. If you have other detail records printing then I would insert a pagebreak right before the graph in the footer (or right after in the header) to have the graph print on it's own page.

[AMEDMERRT1]

WOW! You're great! Can't believe the fix was that simple. Never woulda thought of that without your help. Thanks again. I removed the record source from the Report's Properties box. PROBLEM SOLVED!

[zmbd]

I try...
As you see... even the experts don't get it right the first time!

If your question is solved please click on [Choose As Best Answer]