473,325 Members | 2,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Unwanted Duplicate Graph in Report

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.
Sep 17 '12 #1

✓ answered by 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.

12 4336
TheSmileyCoder
2,322 Expert Mod 2GB
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?
Sep 18 '12 #2
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.
Sep 18 '12 #3
2012 IC-TotalsDesignView.pdf

Here's the report as it appears in Design View. Again thanks for your help.
Sep 18 '12 #4
Would a snapshot of the Query the report is based on help?
Sep 18 '12 #5
zmbd
5,501 Expert Mod 4TB
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?).
Sep 18 '12 #6
Query DesignView.pdf
-
Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCTROW 
  2.    [PT-IC-DATA Query].[DateServiced By Quarter], 
  3.    Sum([PT-IC-DATA Query].CountOfInfectionType) 
  4.     AS [Sum Of CountOfInfectionType], 
  5.    Avg([PT-IC-DATA Query].TotalClients) 
  6.     AS AvgOfTotalClients, 
  7.   Sum([PT-IC-DATA Query].[CountOfPT-ICDATA#]) 
  8.     AS [SumOfCountOfPT-ICDATA#]
  9. FROM [PT-IC-DATA Query]
  10. GROUP BY 
  11.    [PT-IC-DATA Query].[DateServiced By Quarter]
  12. HAVING 
  13.   ((([PT-IC-DATA Query].[DateServiced By Quarter])
  14.      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.
Sep 18 '12 #7
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.
Sep 19 '12 #8
zmbd
5,501 Expert Mod 4TB
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.
Sep 19 '12 #9
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."
Sep 19 '12 #10
zmbd
5,501 Expert Mod 4TB
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.
Sep 19 '12 #11
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!
Sep 19 '12 #12
zmbd
5,501 Expert Mod 4TB
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]
Sep 19 '12 #13

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: mclarry | last post by:
Hi all, I'm currently looking for a tool in Java that will enable me to build web base reports and graphs. Can you point me out any free technology or API that will help me to achieve this? ...
1
by: JD Kronicz | last post by:
Hi .. I have an issue I have been beating my head against the wall on for some time. I am trying to use late binding for MS graph so that my end users don't have to worry about having the right...
3
by: Jeff | last post by:
Hi I have a report with a graph on it and want to change the minimum and maximum values for the value axis when it is previewed. This can't be done by adding code in the Open event as once the...
0
by: savas_karaduman | last post by:
I am trying to create graph report with using query results. Query result show me `total quantities` for some related `category name`. When i attempt to create a Chart Report with wizard by using...
6
waynetheengineer
by: waynetheengineer | last post by:
Hi all, I have a database that has two tables: 1 table shows different types of animals: e.g. rabbits, bears, birds, etc. a 2nd table that links to each animal type that has individual animals...
3
by: ConfusedMay | last post by:
Hi, I need to create a graph report that showed total hours and unattended hours based on certain months and operation code that user input into the form. I have two queries: one to calculate...
2
by: paeh | last post by:
hello..I am beginner in programming..I want to know how to produce graph report base on mysql data? What are programming language should be use? Can anyone give me some coding example to develop...
2
by: paeh | last post by:
moving average is the process that will be executed according to certain schedule such as daily, weekly or monthly based on the data in the database. For your information, I plan to use MySQL...
4
by: DeanJo | last post by:
I am using VML to create a bar graph report, however i have run into trouble trying to come up with a formula to display and draw the grid lines by.... So if i have 3 users... 1 person does 10...
1
by: x7866x | last post by:
Hi I need to find out how to make a query which will show the popular products in the database by area, the database involves a DVD rental system... I have 3 tables in my database .... one with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.