Search results for query: *

I am using CR X with an Oracle DB. I have a range of numbers that I have to split into separate records in Crystal Reports. For example: Range 00001 - 08900 Teacher Titles I need the records to look like the following: 00001 Teacher Titles 00002 Teacher Titles 00003 Teacher Titles 00004...

I am using CR X with an Oracle DB. I am trying to create a identifier for employees that had two or more positions during the same time period. In order to do this, I need to compare dates ranges within a set of records, which is the start date and end date. For Example: If Beth Jones...

I am using CR X with an Oracle database. I have to compare a set of history data for an employee and create a RECORD NUMBER (RCD#). The data is grouped by SSN (Group#1) and it is sorted by Effective Date (EFFDT). Can someone help me put the logic explained below into an actual formula? I...

Hi, I am using CR X with an Oracle DB. I have 100 employee records. I would like to give each employee a 9 digit random number. Please help!

I am using Crystal X with an Oracle DB. I would like to export a large amount of data into a Tab Delimited Text File. However, when I click on export and select "Tab Separated Text" the fields are truncated because I am trying to fit 26 fields in one row. I do not have access to SQL or SQR...

Hi, I am using Crystal 10 with an Oracle DB. I have to convert a large amount of data based on certain field formats. For example, in the Oracle DB, the "Name" field is 60 characters. How can I change the field length to 30 characters?

I am using Crystal Reports X and an Oracle DB. I have approximately 6000 employee records with salaries. I would like to extract 10% of the 6000 employees with the highest salaries. The result should be 600 employees extracted with the highest salaries. Please help!

I am using Excel 2003. Does anyone have any tips on how to create a list of acronyms automatically in Excel 2003. For example, I have a list of departments and would like to create a 10 character acronym for each department.

I am using CR X and an Oracle database. I would like to compare data from two or more dates. For example: As of 10/31 As of 11/5 # % # % Date of Birth Errors 26 15% 6 .5% Date of Hire Errors 27 16% 5 .4% At...

Hi, I am using CR10 with an Oracle database. I need help with, -figuring out how to check employees with the same name and different SSNs -figuring out how to check employees with different names and the same SSNs I have to do the above comparisons within two different databases. Do you...

I am using Microsoft Access 2003. I have two tables. Table 1 Session Table: This table lists all available workshop sessions with the following fields, SessionID SessionName SessionDate SessionTime Table2 Employees Table: This table lists all employees with the following fields, EmployeeID...

I am using MS Access 2003. I have a Event database that I created. I would like to create an option that allows me to assign an event to a group of people with the same "Role" so that I do not have to spend time on a lot of data entry. At this time, I have a number of tables for example...

I am using CR10 with an Oracle database. Here's the situation: I have 2 effective dates in my database which are 10/1/2004 and 10/1/2005. I created a group in my report based on the effective dates, which is GROUP 1. I created a running total in GROUP FOOTER 1 to count the number of females...

I am using CR10 with an Oracle Database. If I have a report that I created previously and I want to change one field on the report to a different field without deleting the old field then dragging in the new field, how can I do this easily? Is there a way to map the old field to a new field in...

I am using CR10 with an Oracle Database. Each time I set the datasource location to a different table or view, the name of the old table still shows up on Field Explorer. How can show the name of the new table or view?

I am using CR10 with an Oracle Database. If I have a report that I created previously and I want to change one field on the report to a different field without deleting the old field then dragging in the new field, how can I do this easily? Is there a way to map the old field to a new field in...

I am using CR10 with an Oracle Database. Each time I set the datasource location to a different table or view, the name of the old table/view still shows up on Field Explorer. How can show the name of the new table or view?

I am using CR10 with a Oracle DB. I have a report that I would like to export into text format with the fixed length of the fields/strings. Does anyone know how to do this? For example: If the Last Name is set at 20 for the field size, I would like to export that field size into a text file...

I am using CR10. I created a Crosstab that looks like the following example. Purchase #1 Purchase #2 Purchase#3 JOE 3% 5% 7% BOB 0% 7% 10% KATE 9% 2% 8% How can I increase the decimal on a percentage...

I am using Excel 2000. I have two worksheets with payroll data from 1 pay period in January 2005 and the other from 1 pay period February 2005. I would like to see the employees that was recently added to payroll by comparing the two files. I do have SSNs in the files. Please Help!