Search results for query: *

Unfortunately, I do not have a table with at leat 8400 record. I only have one record in the table. I would like to duplicate that same record 8400 times. Is there a way to do that?

I created 2 formulas: //REPORT HEADER FORMULA (placed formula in report header) whileprintingrecords; stringvar rangex := "00001 - 08400"; //substitute your range field numbervar start := val(split(rangex," - ")[1])-1; numbervar end := val(split(rangex," - ")[2]); //DETAIL FORMULA (placed...

I added the first formula in the report header and the second formula to the detail section. The result is 1.00. Do you know why I am getting this result?

Thanks LB! However, the suggestion did not work. Maybe I did not explain the situation clearly. I have 1 record, an example of the record is below. Range Description 00001 - 08900 Teacher Titles I would like the records to be split into 8900 separate records. For example...

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...

Thank you! I have approximately 100 records for Beth Jones. Is there a way to compare date ranges, not only for the NEXT and PREVIOUS records, but do a comparison for the all 100 records?

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...

Yes, I would like to randomize the numbers in Crystal. I do want the number to be specific to each employee. Also, the number can change each time I refresh the report.

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!

Actually, it is required that I have up to 10 characters in each ACRONYM. For example: Department of Mathematics - ACRONYM: MATHEMATIC Department of Mathematics and Computer Science - ACRONYM: MATCOMPSCI Department of Music ACRONYM: MUSIC

Hi John, The problem is that the depends are not the same in length. For example: Department of Mathematics Department of Mathematics and Computer Science Department of Music I would like to create acronyms for each of the departments listed above, but the length must be 10 characters. I do...

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...

Thanks maxhugen! I'll try your suggestions.