473,946 Members | 20,623 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Charts on a report question

Hello

I have set up a database of students in a program, mainly for
statistics. The report I'm having trouble with right now is one that
graphs admission rates on a per-term basis.

Here's what the report looks like without the graphs (obviously it's a
lot better than I can post here, but this is the gist of it):

Start Date by Month Status Applications
Sep 2002
Admitted 62
Percentage of Total 63.3%

Declined 19
Percentage of Total 19.4%

NF 6
Percentage of Total 6.1%

Not Eligible 11
Percentage of Total 11.2%

Applications for Term 98

Jan 2003
Admitted 19
Percentage of Total 65.2%

And so on, up through September, 2006. All of the data is from a
cross-tab query called "Applicatio n Status by Start Date" that totals
the number of applications into rows divided by start date and status.

Now, I would like to put a pie chart for each term with the
percentages for that specific term. So it would be:

Term information
chart of that term information
Term information
chart of that term information

However, when I set up the chart, it always wants to take the grand
total of applications rather than the subtotal by Start Date. Thus,
all the graphs are exactly the same.

Is there a way to graph the subtotal rather than the grand total? Can
you reference controls from the report on the graph, or only fields
from the query?

Does the query need to be changed? If it would help, I can post the
SQL of the query the report is based on.

Thanks!

Dave
Mar 23 '06 #1
0 1116

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
4374
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have to code a solution to this it'll probably be done in ASP on a web server, unless there's a significantly better way. I'm looking for a way to create over 100 Excel *charts* programmatically.
5
3219
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have to code a solution to this it'll probably be done in ASP on a web server, unless there's a significantly better way. I'm looking for a way to create over 100 Excel *charts* programmatically.
1
3200
by: Patrick Stephens | last post by:
Hi, I produce a 30 page report that has data and two charts per page, using Access 2000. My boss wants the report in WORD format. When I use the "office links" to "Publish it in Word" I get all the text but not the charts. Any Ideas?? -- Regards,
0
1184
by: parrishioner | last post by:
I'm working with an Access 2000 report that displays a number of bar charts. The charts tend to have 1 to 5 bars on them, but occasionally there is a chart with about 20 bars. Because of these variations, using a consistent gap width for all the charts doesn't yield the most attractive results. Here's how I have attempted to get around this... Private Sub <hdr>_Format(Cancel as Integer, FormatCount as Integer) With <graph>.Object If...
4
1943
by: Wayne | last post by:
I have posted this problem a couple of times over the last few years but have been unable to find a solution that works. Sometimes charts in reports will display showing the design data instead of the actual query data the first time they are opened. If the report is closed and reopened the correct data is shown. This seems to be a nasty Access bug that has carried across the last few versions at least. One post that I saw on the...
0
1188
by: Bilal | last post by:
Hi I'm using Visual Studio 2003 So I developed a Web based Crystal Report, So I got success in this manner. But the Only problem I'm Facing is that, when i make Report in Design Mode in Vusual Studio ASP.Net web form. The whole Report e.g., Data, Charts are displayed in Design Mode, only thing Menu Tabs are not
18
2741
by: DFS | last post by:
I posted this question yesterday, and nothing but silence. I looked through cdma in Google, and it seems whenever someone posts questions about scatter charts, they get ignored. So, hopefully, this time, someone will have some brilliant response to share. Starting with the Chart Wizard, I can't get the Access scatter chart to place the data points correctly, ie at the intersection of their XY
0
1252
by: lucoto | last post by:
Hello, I'm trying to use Crystal Reports in my application but I'm not sure if it's possible in Crystal to do what I need. My app generates an array of reports: Report rep_array; class Report { int some; int useless;
0
1046
by: bikram3005181 | last post by:
How to generate series of charts dynamically ? I have report parameter called location which has 10 locations. on each selection of a location, one chart is shown. How to generate 10 charts for each location on single click? Dynamically the report parameter location has to be passed and dynamically different charts has to be generated on a single report so that i can export all these charts to pdf.
1
1124
rcollins
by: rcollins | last post by:
I have a report from a survey that I am adding a bar graph to. I have thi info sorted by location. I have the average of each question, 1-16, in the chart. There are 13 locations, so I end up with 13 charts, since I put the chart in the etail section of the form. Along with the information for each location, I would like to add in the corporate total average in the same graph. I understand how to do this in excel, but am new to charts in access....
0
10151
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9980
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11557
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
11333
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
8247
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7412
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6111
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6328
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4933
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.