I have created a report using a query. Further to this, I have added some fields from the query into the report which calculates the sum of records and the count of records.
My problem here is, using the chart wizard, I am only able to select the fields existing in a 'Table' or a 'Query'.
Can anywone help me to create a Bar chart / Pie chart using the fields in the report? :confused:
I am working in Access 2010, trying to create a report with a pie chart. The pie chart is based on a query (called Count Pie) that calculates three values:
% IS
% NetInf
% IS + NetInf
I go into Create, Report Design and get a blank report in Design View. I select Chart from the Controls tab and follow the Wizard to specify the data source.
I get a pie chart with the right title (Count Pie). I double-click on the chart to open the report Datasheet and insert the correct value names. My pie chart in Design View looks correct. It has the right title and legend, and shows three slices of the pie corresponding to the three values.
I save the report, and go to Print Preview, where I get a pie chart that looks like a single circle; it has no legend, and doesn't show the three values.
Do I need to have the Access 2010 application re-installed?
I am having trouble creating a chart within a report. Let me start off by explaing my report.
I have many unbound textboxes on my report that all have the code very similar to this:
" =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour? (Y/N)]="Y",0))) "
This basically gives a count of for a specific month. There are twelve rows of text boxes and two columns. There is a query applied to the report to input the year, as this is a yearly report.
What I want to do is link a chart to each and every text box to show the data in an easy to view format. But I can't seem to figure it out, and I've had no luck on the web .
I have this database where I track how long an employee has been with the company. I need to make a chart to show this data. I've got a field that calculates how many days the employee is/was with the company. I now need to group them into categories:
Less than 7 days
Less than 1 month
Less than 3 months
Less than 6 months
Less than 1 year
1 - 2 years
2 - 5 years
5 - 10 years
10+ years
Question is...since charts seem to need to pull from only one source how the heck can I the counts for each of those criteria above into one query or table. I've got them all in separate queries right now because I can't figure out if there's any other way.
Anyone know a good site w/ help creating charts in Access 2k? I have a few queries id like to display as charts but just playing w/ the chart feature is getting more confusing by the minute. Any tutorial would be great. TIA!
View 1 Replies View RelatedI'm creating a database using existing data from an excel file full of contact details. What I need to add is a queue type system where each contact in the database has a "Place in Queue" number which is unique obviously.
Lets say Alan is number 1, Bob is 2 and Chris is 3. They have these corresponding numbers in the queue field for their entries.
Now what I need to have, through use of a form, is a way of changing Chris from number 3 in the queue to number 1 and thus have Alan automatically shift down to number 2 and Bob to 3.
Wasen't sure whether this is a Reporting thing or a Querie thing as it resides inbetween the two.
Basically (and believe me I thought this would be pretty straight forward!!!!), I am trying to create a chart from a query that returns the occurences of concerns raised each month for a year. The query returns the following:
MthTextExpr1
Jan0
Feb0
Mar0
Apr1
May0
Jun0
Jul1
Aug1
Sep2
Oct1
Nov0
Dec0
In order that the user can specify a year that the chart will be applicable to, there is a field within the query that relies on the input of a year on an unbound text box on a form: [Forms]![frm_concern_frtpage]![Enter Year] is inputted into the critera box of this field.
However, if you try to create the chart it does not like this and just gives the following two error messages. If you enter a value into this text box and run the report containing the chart, it just gives a blank chart!!!!
Why is this error occuring?
I just want months along the X axis and the values from the Expr 1 column to be displayed on the Y axis!
I have browsed a few forums and am still having trouble creating a pie chart that has the proper layout that I would prefer.
I have created a query that will list the data I would like to organize into a pie chart. The query, when run, will prompt the user for a start date and an end date and then display the data in this form:
EmployeeX | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
EmployeeY | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
OK, now that I have the data in this format I would like to create a report that includes tabs for each employee, each tab will have a pie chart that has one employee and a pie chart showing how their hours are allocated to each task. e.g. tab 1 would have Employee X and the pie chart would show what percentage of this employee's hours was dedicated to project/demo/admin/etc...
I've written this code in Access to create a pivot chart in Excel. All the code listed is good except for the last line. The last line creates another instance of Excel. I can't figure out what the correct syntax is.
Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb1 = xlApp.Workbooks.Open("c:chi estpivot.xlsx"
wb1.Sheets.Add
wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
[code]....
I have a chart that shows the amount of complaints every month in the last year of a selected costumer. The goal is to see if the amount of complaints from this costumer is decreasing or increasing.
The problem is that some smaller costumers have months without complaints (in real life that isn’t that bad). But my graph only displays a dot for the months were the amount of complaints is not null. This makes that the graph line doesn’t show the complete picture.
I know that I should be able to solve this with an ISNULL expression. I have tried the following SQL code as Row Source of the graph:
SELECT (Format([Complaintdate],"MMM 'YY")), ISNULL(Count([Complaintnumber])),0 AS [CountOfComplaintnumber] FROM [Complaints] WHERE [Complaintdate] > (Date() -365) AND [Costumername] = Forms!Report_complaintscostumer!Combocustumername GROUP BY (Year([Complaintdate])*12 + Month([Complaintdate])-1),(Format([Complaintdate],"MMM 'YY"));
The result of this is that all the months with complaints now get a 0 value and still the months without complaints aren’t shown.
What am I doing wrong? Could someone help me solve this problem? Any help is greatly appreciated!
Hi,
I have a field in a form which displays the Sum of 10 values from other textboxes. I want to display the values of that calaculated field in a report and somehow I am stuck. I am running the report based on a query.
How would I get those field calculation values to display in a report?
Thanks
dfuas
I have show results of scores on a graph but need to show if those scores fall below, in between or above acceptable limits. For example, lets say the acceptable range is between 10.5 and 15.6 but people can scores between 0 and 50. So what I need to do on a report chart/graph is show the actual scores in columns, let access automatically adjust the scale, but have the area between 10.5 and 15.6 on the scale highlighted or coloured or perhaps indicated by two horizontal lines across the chart/graph.
View 5 Replies View RelatedAccess charts know if it's possible to change the value axis values.
I create a chart getting values from a query I run, it plots the values but auto selects the value range and the increment.
The values on the value axis are : 0, 0.25, 0.5, 0.75, 1
Is there anyway I can get the values to increase by 0.1 rather than 0.25?
Report repeats the SAME chart for each value on the x-axis (i.e. x-axis is the date and same chart repeats for each month). The chart on the first page is correct and is the only chart I need. How can I change the settings of the chart so the report is the first page???
View 1 Replies View RelatedI have a query written that has two numbers. One is the trucking fleet size (63) and the other is the average number of trucks used over a time period (in this example, its 52.2)..I just want to create a pie chart that has 52.2/63. so the pie would be roughly 90% filled.
View 2 Replies View RelatedI don't seem to get it right to use a chart in my reports from a query.
See attached database. I want to create a chart in the report to give visual feedback to the user.
We have a chart that is showing jobs by customer. I'd prefer it be in a pie chart but it's way too many to read. We changed it to a bar which is much easier to read but it displays the percentages as 100% for everything.
View 5 Replies View RelatedI am working on a project that is requiring me to hide a subreport that happens to be chart graph, when the chart has no data and my problem is that I cannot seem to get the report to properly hide and show the label behind it when the data is not there. I am in need of a SQL code that will read my blank record source as a zero instead of blank. I have tried Nz, IsEmpty, and IsNull and none of them seem to work.Here is the current SQL code:
SELECT DISTINCTROW Sum(Case_review.ID) AS SumOfID
FROM Case_review
WHERE (((Case_review.[Type of Issue].Value)="Clinical"));
Here is the current VBA code (which is in event on load) for the main report:
If Me.Rpt_Clinical.Report.HasData = -1 Then
Me.Label29.Visible = False
Me.Rpt_Clinical.Visible = True
Else
Me.Label29.Visible = True
Me.Rpt_Clinical.Visible = False
I am trying to run simple query make a chart in report through this query but its not generating chart?
SELECT [Unsafe Act Unsafe Condition].[Inspection Audit], Count([Unsafe Act Unsafe Condition].[Inspection Audit]) AS [CountOfInspection Audit]
FROM [Unsafe Act Unsafe Condition]
WHERE ((([Unsafe Act Unsafe Condition].Date) Between [Forms]![frmSafetyReportOut]![startDate] And [Forms]![frmSafetyReportOut]![endDate])) OR ((([Unsafe Act Unsafe Condition].Department)=[Forms]![frmSafetyReportOut]![cboDepartment]))
GROUP BY [Unsafe Act Unsafe Condition].[Inspection Audit]
HAVING ((([Unsafe Act Unsafe Condition].[Inspection Audit]) Is Not Null) AND ((Count([Unsafe Act Unsafe Condition].[Inspection Audit])) Is Not Null));
I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.
Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).
How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?
Colm and Baxter, you've been great helps to me so far, and I will include you in the special thanks in my programming credits. I ask your help once more-
My program tracks how many calls are received per day at the office. I have a report showing a chart (thank goodness for wizards ) that lists the calls per day. This all works fine, and I was extremely proud of myself for doing so. However, after thinking about it, I realized that after a while, my client might not care to see ALL of the calls per day ALL of the time, and might wish to see maybe a week's worth or a month's worth at a time. I was thinking I could solve this by using a form to enter "from" and "to" information, but I'm not quite sure how to apply this so it would work with my report.
Also, if I can get this to work, on this same form I would like to have an option field that the user can select so that the usual options (today, this week, this month, this year, all) require only a click, rather than having to figure out what days are in this week (a tedious task, I know, but we're going for efficiency here ) but they also have the option of seeing specific dates they want.
The fields that I'm using for this are very simple- tblCustomer.CallDate and tblCustomer.LeadType, where CallDate is just a date and LeadType is a string from a lookup table that is either "Call-in" (the one I'm tracking) or "In-field".
I know this sounds like a lot of coding, but I'm sure if you could get me started, I could figure out the rest myself. It's just that the way Access does dates is so confusing to me, and I have midterms coming up and not a lot of time to figure this out by myself from scratch. Anyways, thanks for your help in advance!
Jason
linking a report and a subreport (chart). I have uploaded my sample DB. I'm trying to chart all the individuals and three fields for each Home. Both report and subreport are using the same query for the record source. My charts are blank "All_Homes_Individual_Totals". Just use date range 05/01/14, 06/24/14 on my Main form page for the data.
My second question is how would you create a chart to pull by each individual with their monthly totals per Home using "qry_Community_ Inclusion_ All_Homes" with a report and subreport (chart) as above. Report would show the individual's totals by month for each home.
How can I create a chart to be added to the last page of an access report to summarize all the data reported?
View 1 Replies View RelatedI have problem that my chart in report cannot display values in "percentage" as it is in query no matter what.
Sample is in the attachment.
I have data in a chart over four groups that are just labeled A, B, C and D in the underlying data. The table wants to label the x-axis of the chart SumOfA, SumOfB, SumOfC, and SumOfD. Ideally I would like to drive these labels by text boxes on a form, but I can't even figure out how to change them manually. I got to the data table in the chart designer and changed them there, and they'd show as changed in design view, but then they weren't changed in report view.
View 5 Replies View RelatedI am having a terrible time getting this to work. I have a mainform that contains 11 multi-list boxes. That mainform when I select whatever I want in any of the 11, select all items in each of the 11, or select nothing and click my show results works great. In my detail section it displays the information it should. I need to now take that and put it in a report with a pivot graph. I created a subform that is my pivotgraph and the reason for a subform is the end-user still wants the ability to filter more should they choose.
In addition, the regular graph you can put in the report does not allow me to put in multiple items. For instance I need to have sumofmbrstargeted and sumofmbrsconverted in the values and it will say I can only choose 1 value and then it will say up to 6 items and I have a 8. So, I opted for a subformpivotchart. If I create the following code, the subform updates based on the filters on this mainform everytime. Works like a charm.
Code:
Private Sub cmdGetGraph_Click()
DoCmd.OpenForm "Graph", acFormPivotChart, , GetFilterFromListBoxes
End Sub
The problem is, I want the Graph in my Report. If I take the Report and do the same basic thing:
Code:
Private Sub cmdGetReport_Click()
DoCmd.OpenReport "Search", acViewPreview, , GetFilterFromListBoxes
End Sub
It asks for the parameters again. Example, LOB, Plan, Prod_NM. I tried just disregarding the report and created yet another subform for the reporting piece and embedded the graph and that still asked for the parameters. It works great for the subform as the graph and I want to have the ability to use the GetFilterFromListBoxes, apply it to the Search Report with the embedded Graph.