Search results for query: *

Hello to All, I am using Crystal Reports Version 10. I have created a conventional crosstab with employee serial number in the rows and with unit of assignment in the columns. There are about 20 units of assignment in total. I am counting issued traffic tickets in the summary field. It is...

Hi, I am using CR10 against an MS 2010 Access Database. This is a project database and for each project number in the database, the project officer will enter remarks that are stored in a Remarks table. The relationship is a one to many between the project number and the associated remarks...

I am running Crystal V10 using an Oracle database. What I am trying to do is include all detail records in a group based on the value of a field that may be present in only one of the detail records. Think of this as the opposite of suppression. I found many threads regarding how to...

I am using Crystal 10 with an Oracle database for a law enforcement 9-1-1 report. The report needs to accumulate committed time of all officers for area by hour-of-day for a three month period. The chart below shows what the report should look like, except there will be 24 hours going across...

I have looked extensively through the Crystal forums, but could find nothing that relates to the situation below. I am using Crystal 10 against an Oracle database. The report I am trying to create will look, by way of example, like this: Hour # of # of of One-Officer...

I am using Microsoft Access 2000. The code below resides in a subform. Using the DMax command, strRevisionDate is loaded with the largest TDateRevised value that can be found in tblTDateRevision for a given Project Number. The SQL statement then updates the field SupervisorTDateRevised (found...

I am using Access 2000 and have constructed a project logging system. ProjectNumber (the key field) exists in table ProjectMain. Two tables are linked to it by ProjectNumber in a one-to-many relationship: ProjectAssignment and ProjectActivity. The activity logging process takes place in a...

I work for a law enforcement organization that has a large inventory of Word templates which are used for filling out reports in the field. Each template is specific to a particular activity (Field Incident, DUI, Request for Lab Analysis, etc.). Most templates are made up of several sections...

I am using Access 2000 and have been vainly scouring threads for the last day an a half in an attempt to find a solution to this problem. While some threads are close, I have not been able to successfully adapt those suggestions to my problem. Scenario: I have two forms (Form1 and Form2) from...

I am new to Access but have a developer's background on mainframes. After researching several FAQ's and threads in this forum and not finding an answer, I decided to go public with my problem. I am using Access 2000. I created a form that is made up of a series of fields from one table. In...

I am using MS Excel 2000. I have created a protected worksheet to prevent users of the sheet from changing formulas, header columns and other cells that contain informational text. Users, however, do have access to other cells in this sheet where they can enter text. Protecting the worksheet...

I am using CR 10.0 that reads an Oracle database (not sure of version). I have created a main report and unlinked subreport. Both reports list very similar data. Different conditions (individuals who have 20 hours to complete a task and individuals who have 24 hours to complete a task) result...

My SQL server database contains employee serial numbers stored as a character (string) field although all serial numbers are numeric. When making sales, employees are allowed to enter their serial number with a leading zero or without a leading zero. Most employees use only one or the other...