Reports :: Showing All Categories With And Without Records

Oct 2, 2013

I have a bunch of records that are assigned to categories which are problem tickets. I would like to print the report showing not just the categories that have records open in them now, but also ones that don't have any records in them. So say I have these three categories. Power, Circuit, Hardware failure..If I have a few open tickets in circuit and hardware failures and none in power. Power will show show up on the report but with no records listed underneath it.

View Replies


ADVERTISEMENT

Reports :: Showing All Detail Records If One Record In Query Meets Criteria

Mar 5, 2013

I am trying to create a report which basically includes the following:

Company, Wages, Contribution.

Each company reports wages for each employee every month. Then they also contribute to a general fund based on a percentage of the wages. For instance:

Company---Employee---Wages---Contribution
CompanyA---EmployeeA---$4000---$40
CompanyA---EmployeeB---$3800---$38
CompanyA---EmployeeC---$3800---$38
CompanyB---EmployeeA---$4200---$42
CompanyB---EmployeeB---$4200---$42

...and so on.

Each employee is required to contribute, in this example, 1% of gross wages to the general fund.

On occasion, the company does not pay in the required 1% of gross, say, for CompanyA EmployeeA, they only paid in $35.

Here is what I need to do. If any contribution amount for any employee is incorrect, I want to display all the records for that company, not just the incorrect ones. The report is grouped by Company, and may contain dozens of companies.

I am already passing a number of criteria to the report using a filter, including the date range and other fields which are informational.

View 6 Replies View Related

Tables :: Structuring Categories And Sub Categories

Dec 27, 2012

Suppose I receive boxes and store them in a room. Each box can contain items that are either shaped as cubes or spheres and I have to allow for the addition of more shapes in the future, but only one shape can be in each box. Each box contains a random number of shapes and two boxes may, or may not, contain the same number of shapes as another.Cubes can be either Red or Green, Spheres can be either Blue or Yellow.

I wish to set, and have the ability to change, how many cubes and how many spheres, on a percentage basis, I wish to have (e.g., 60% Cubes and 40% spheres).I also wish to set, and have the ability to change, what percentage of cubes I want to be Red and Green and which percentage of Spheres I wish to be Blue and Yellow (e.g., Cubes -Red 70%, Yellow 30% )

e.g. -- I have several boxes totaling:

Cubes
Red 30
Green 40

Spheres
Blue 10
Yellow 20

My goal is to produce three reports.The first report would provide the Target and Actual number of Cubes and Spheres expressed as a Value and %. The #'s would simply be calculated from my desired % . So, if I wanted to have 60% cubes and I had 100 Shapes, my target # would be 60. If I had 200 Shapes it would be 120. (i.e., The actual number of shapes I have is simply a factor of how many I receive and I have no control over this.)

The First Report would look like this

Target % - Actual % - Target # - Actual #

Cubes 60% 70% 60 70
Spheres 40% 30% 40 30

The second and third reports would be the same format but would break down cubes into red and green and spheres into blue and yellow.I can accomplish the Report that breaks down the shapes but I am running into problems with the next level as I need the total number of shapes and the the total number of only Cubes or Spheres to insert into the expressions.

View 2 Replies View Related

Reports :: Showing Up To 28 Day Average?

Jul 22, 2014

What I am thinking of is to have a fairly simple table, as follows:

Date
Supervisor Name
Day type (Sat, Sun or Weekday)
Duty Number (combo box, looked up from a separate small table)
Time Start (auto-completed based on Duty Number)
Time End (auto-completed based on Duty Number)
Target A (which would be a number such as 1.20 or 0.90)
Target B (which would be a percentage such as 85.00%
Result A (same format as Target A)
Result B (same format as Target B)

Restriction (whole number, no decimal places)
Output 1 (percentage)
Output 2 (percentage)

Then have a report that shows each day's data for each day worked, with a set of text boxes at the bottom of the page in the footer area most likely, that show the average of all Target, Result, Output and Restriction fields for all the dates shown on the report.

It would be most likely to be ran for a 7 day period or a 28 day period, but if it could be made able to cope with any number between the dates specified at the time that the report was being pulled, that would be ideal.

Is this possible, and what would the code be to get a field to calculate the averages at the bottom (I presume that this code would have to be different to handle the decimals or the percentages?)?

View 2 Replies View Related

Form Values Showing As 1, 2 3 Etc In Reports

Jun 15, 2005

Hi Guys,

I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for.

I have a table which is use for a drop down list in my forms.
This is saved into a table, but shows up as a numerical instead of the name value.

Also In reports, I get a numerical value, instead of the text value.

Is there something I`m over looking ?
Or am I doing something totally wrong.
My relationships are correct. and the field data is right, I just cant over come the number issue.

Thanks in advance.

View 6 Replies View Related

Modified Reports Are Now Showing Errors

Apr 13, 2005

I modified some reports in my music library database to have the composer first name and last name appear as one field. I'm not sure what is wrong with them, and request another pair of eyes look at them to see if the error(s) can be found. Please bare with me, this is my first post to this forum so I'm not sure if I am following the rules correctly, yet I have posted to the Java area before. I'm not sure what I should include for help, since when I try to include my database in *.zip format, it is saying it is too big to send. Any ideas on what I should send?

View 2 Replies View Related

Reports :: Report Showing Primary Key But Not Value?

Apr 21, 2013

I have a query that runs - off the back of this, a report. The query will show a name eg dave however the report will show Daves unique key (eg 3) and not just say dave how do I sort this?

View 2 Replies View Related

Reports :: Showing Null Values?

Jun 9, 2014

I have a list of departments, 1-17, where each needs a SUM of their price for each end of day.

At first I was going to make 17 queries, and place each into a new sub-report, but there must be a way to list all 17, even if they haven't had a sale put through.

I've tried linking using "show all values in tblDept and only those that match in tblOrder" - but I cam across a very obvious issue.

The items are grouped by Z1 Number, a unique number for the end of day sales. If there is no department linked to a Z1 number, then it won't show it. For example, if there were no sales in dept01, then there is no record under tblOrder to show a Z1 number for dept01 - so there is nothing to link to in the report.

I was then thinking of creating false data at the end of day so the Z1 number mentioned each department at least once, but that would get messy and not 'normal'

I'm thinking of a type of loop to generate the report so a 17 row report is generated,

View 5 Replies View Related

Reports :: Field Not Showing Values

May 14, 2013

However, the data is now showing on the generated invoice.The rest are showing up but one.I went back to the tables to check and there is data present.It used to work until recently.

View 3 Replies View Related

Reports :: Subreport Not Showing On Main Report

Jan 12, 2015

I have a main report with one subreport. The main report contains details of a payment being made to a supplier. There is the total amount being paid, and the cheque number being transferred. There is also a field called payref which is made invisible. This is used to link up with the subreport. The amount is the total of several invoices for which payment is being made.

The subreport contains details of each of a number of the invoices being settled. The subreport is linked to the main report via a common field called pay-ref, and the subreport is 'visible'. The subreport prints when placed in the page header section of the main report. However when there is a large number of invoices being shown in the subreport only a certain number appear. It appears that the subreport can only hold a certain number.

When the subreport is put, as it should, in the detail section of the main report, it does not appear at all in the main report. I have no clue why and I have made several reports like this one before.

View 2 Replies View Related

Reports :: How To Hide A Record When Yes / No Box Showing False

Jun 23, 2014

How to hide a Record when "False" or a box is unticked on the report.

I've used a Query for the report and figured it would go in the Criteria for the tick box but can't find the code I need (I am sure it is simple)

View 2 Replies View Related

Reports :: Report Showing Data From Previous Run?

Feb 9, 2015

I have a REPORT containing 7 ('columnar') subreports. Each subreport is to show showing a days worth of medical doses.... to visually represent a wall planner.

When the report loads - user enters a week value # via Inputbox(). This value is written to a TEMP table. Each subreport accesses this same TEMP table to retrieve the week # value. In the Recordsource for each subreport I have the following code :

SELECT * FROM GETPATIENTREADINGS_WEEK WHERE (((Format([DateR],'ww'))=DLookup("WeekVal","[TEMPTABLE]")) AND ((GETPATIENTREADINGS_WEEK.DayVal)=1));

... where the DayVal goes from 1...7 corresponding to the columnar position of each subreport on the display ie. for each day of the week.

The problem I am having is that when the report runs - I see the display showing the data from when the report was previously run. ie. I have to run the report twice to see the data for the correct week value entered. All the SQL works as expected when I run from Query view but when I run through VBA..

View 3 Replies View Related

Reports :: Check Boxes Showing On Report

Apr 22, 2015

On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name.There's nothing in my report to show that I have these checkboxes on the report. Where these could be coming from and why they only show in the Print Preview layout?

View 2 Replies View Related

Reports :: Subform Only Showing Last Group Record

Feb 25, 2014

I have one query that the main form is based on and another query the subform is based on.

I linked the subform to the main form by a common field "Branch"

My main form displays Grouped Employee overhead totals based on Branch

Example:
Branch 1 Employee overhead cost...........15,000.00
Branch 2 Employee overhead cost...........25,000.00

The subform displays grouped branch expense overhead totals based on Branch

Example:
Branch 1 Branch expense...........125,000.00
Branch 2 Branch expense...........155,000.00

I am trying to display both the employee overhead total and branch expense in the Branch Header of the mainform.

Example:
Branch 1 Employee Overhead...15,000.00 Branch Expense...125,000.00
Branch 2 Employee Overhead...25,000.00 Branch Expense...155,000.00

I tried using an IIF statement in a text box in the mainform branch header section to return the branch expense if subform branch = mainform branch.......When I run the report I get all of the Employee overhead but only the last record for Branch 2 branch expense displays.

Example:
Branch 1 Employee Overhead..15,000.00
Branch 2 Employee Overhead..25,000.00 Branch Expense...155,000.00

Then, I tried just putting a text box in the main branch header subreportName.Report.TotalField

When I run the report it returns all employee overhead with the Branch 2 total for every branch in the mainform...

Example:
Branch 1 Employee Overhead..15,000.00 Branch Expense...155,000.00
Branch 2 Employee Overhead..25,000.00 Branch Expense...155,000.00

View 4 Replies View Related

Reports :: None Of Query Data Showing On Report?

Mar 6, 2014

I created a Report from a query. The query shows the correct data that should be on the Report. I created the report to sort by Field A and then sum Fields D, E, & F. None of the query data shows up on the Report. I;m stymied as to why I can see data on a query, but the ONLY data that shows up on the Report is Field A. None of the summations show. All are blank with the box outline.

I've created the report 3x thinking I did something incorrect. Whatever it is, I did it 3x!

View 4 Replies View Related

Reports :: Calculated Field Showing Blank

Feb 11, 2014

I'm working with a report that totals the number of times a topic is returned from a query. If a topic is not returned at all, i don't want it to show at all. Currently it is showing a blank field for that topic name and blanks in the count as well. Here's the filter i've put in to pull the right data out of my query: =Sum(IIf([Caller Used Resources]="No",1,0))

View 2 Replies View Related

Forms :: Current Record Not Showing Up On Reports?

Jul 11, 2013

I have a form with command buttons to preview reports. For some reason only the first record shows up on the reports and not the current record.

View 10 Replies View Related

Reports :: Showing Unlinked Data From Table

Mar 26, 2015

I have three tables.

The first is my table of pupils which is linked to the second table: a list of awards and a score 1-5

My third table is the list of 10 awards.

My problem is that (in my report) I want to show all 10 awards for each pupil regardless of if they have achieved them. I'm struggling with the underlying query to always show all 10 awards.

So, little Johnny has achieved a score of 5 in two of the awards, however the report card will show blanks for the remaining awards on his report.

View 4 Replies View Related

Reports :: Subreport Not Showing In Main Report

May 2, 2013

I have a subreport with bitmap files attached, the sub works great until I link it to the main report then the sub shows nothing.

View 2 Replies View Related

Reports :: Leading 0 Not Showing For Date On Report

May 28, 2015

On report, date shows as: 5/23/2015

I want it to show as: 05/23/2015

The input date in main table has the same format as the fields without the '0'.

Property for all date fields appear the same...

View 5 Replies View Related

Removed And Returned Items Keep Showing Up In Queries & Reports

Feb 14, 2008

Good afternoon!
I have a database that tracks the withdraws and returns of shared tools.
The withdraw form has a check box on it that is checked to show removed when the item is ordered (this keeps that item from showing up in inventory searches). When the item is returned, that check box is unchecked, showing that the item can be withdrawn again.

When a person withdraws an item their supervisors name is also logged so that we know who to chase down when the item doesn't come back.

I have a query that is supposed to show what items are still outstanding based on a date range (I got the prompt for date range to work..yea me). However, the query shows every time that the item was borrowed.

Example...
I borrow a hammer and my supervisor is Bob. I return the hammer. It does not show as still withdrawn in my query.

The next I borrow the same hammer and again my supervisor is Bob. I return the hammer. It does not show as still withdrawn in my query.

The day after I borrow the same hammer and my supervisor is Joe. I return the hammer. It does not show as still withdrawn in my query.

Some other day I borrow the same hammer and my supervisor is Joe. I do not return the hammer. The two times I borrowed the hammer with my supervisor as Bob show up as well as the other time that I borrwed it with my supervisor as Joe shows up as well as the one that shows I still have it.
. One of the criteria in the query is essentially only show the items that have the check box checked (criteria=true). But that apparently does nothing, or (more than likely), I am doing something wrong.

This is the SQL:

SELECT tblOrder.OrderDate, tblOrder.Supervisor, tblEmployee.EmployeeFirst, tblEmployee.EmployeeLast, tblItemSpecifics.Description, tblItemSpecifics.Serial_Number
FROM (tblEmployee INNER JOIN tblOrder ON tblEmployee.GlobalID = tblOrder.GID) INNER JOIN (tblItemSpecifics INNER JOIN tblOrderInfo ON tblItemSpecifics.Serial_Number = tblOrderInfo.Serial_Number) ON tblOrder.OrderNumber = tblOrderInfo.Order_Number
GROUP BY tblItemSpecifics.Removed, tblOrder.OrderDate, tblOrder.Supervisor, tblEmployee.EmployeeFirst, tblEmployee.EmployeeLast, tblItemSpecifics.Description, tblItemSpecifics.Serial_Number
HAVING (((tblItemSpecifics.Removed)=True));

View 5 Replies View Related

Reports :: Showing Image Based On Another Field (Date)?

Apr 8, 2013

I need to show an image called PAID if my hidden field Paid Date has a date in.

I thought this would be straight forward but so far nothing.

I have my images within the database itself on Access 2010, so I am not referencing any in a C drive or other location.

Code:
Private Sub Report_Current()
On Error GoTo ErrHandler
If paiddate = Date Then
Paid.Visible = True
Else
Paid.Visible = False
End If

ErrHandler:
MsgBox "Error detected, error # " & Err.Number & ", " & Err.Description, vbOKOnly, "Error"
End Sub

But with no joy.

View 8 Replies View Related

Reports :: Newly Entered Info Not Showing In Report?

Mar 26, 2014

I have a very simple report that is generated from a table. There are no queries associated with this report. When new information is entered into my table I run the report and the new information appears. It has been working correctly for months. Now all of a sudden after the new information has been entered it doesn't show in the report.

View 4 Replies View Related

Reports :: Copy Of Report Showing Enter Parameter Value

Aug 15, 2014

Need to track donations in two areas. Have one query that tracks them in location A and one that tracks them in location B. Same query, no other difference. Report made on location A is fine. Made a copy of it and based it on the 2nd query--and I get a pop-up "Enter Parameter Value" for Last Name. The Last Name field is not in the query or anywhere in the report that I can find.

View 3 Replies View Related

Reports :: Chinese Text Showing In Memo Field

Jun 26, 2015

I have a report which when I open it by clicking the button in the form shows what looks like Chinese text in the memo field. To open the report the following is in the event properties for the referencing button

Code:
Private Sub cmdPrintSumReg_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False

[Code] ...

When I open the same report from the reports menu on the left of the database it is just fine. But obviously it is showing information for all contracts and not the any one contract.

I haven't changed anything in the table that contains the memo field and this only started happening yesterday afternoon after using this db for over a year.

I found an earlier post in this forum with a similar problem but the only difference I see is that the user changed the field from a text to a memo. I haven't.

View 5 Replies View Related

Reports :: Fields Not Showing All Data (Displaying Around 250 Characters)

Jan 21, 2015

I have a report that runs from a query with fields but for some reason its not showing all the text in the field it only shows around 250 characters, I have the field to auto grow in size but still not working?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved