Search results for query: *

I have 2 tables with multiple records per employee. I am trying to read each table separately to sum specific records in each table. The sum of the values in 1 table will be added to gross wage and the sum of the values selected in the other table will be subtracted from gross wage. Table 1...

Sorry....I am using Version 8.5

Does anyone know a way to eliminate the first position blank that appears in a text file export? Each record has a 1 position blank at the start of each record. It happens consistently on all my text exports. I am not free to download the patch because I have an OEM version of Crystal...

Thanks...worked like a charm!

I am using the following formula to strip the decimal point out of a 7 position numeric field when I export to a text file. Is there an easy way to use this formula to also remove the comma thousands separator? replicatestring(" ", 7 - len(replace(totext({@gross_adj}),".",""))) +...

I have reports that I export to Text format. I do not find a way to save the export parameters such as characters per inch and file name/location I want to save the report to. Any ideas on how to default this information so everytime a user runs the report they are not required to find and...

I need help exporting a numeric field, length of 11 with 5 decimals to a text file and have it appear with leading spaces, 4 decimals and show the decimal point. The field contains hours worked (i.e. 40.00000) Can anyone help me with the formula to do this export? Thanks!

I wasn't very clear in my first post. I am using Version 8.5, with an OLE DB supplied by my payroll software. Here is the formula for the 2 fields I am trying to export. Both are numeric fields with 2 decimal places. curhours is a 15 pos. field and needs to export as 4 decimal places and...

I am trying to export a concatenated record with 2 numeric fields at the end to a text file using the following format. The first field is 15 positions...4 decimal places and I want to display the decimal and have leading spaces to fill the field. The 2nd field is 10 positions....2 decimal...

In order to properly export to a text format do I have to convert all of the number and date fields to strings? Since I have not done so, it appears to cutoff these fields and display only a portion. Thanks

I am looking for a way to create my report so that I can start each field in a specific position for exporting purposes. I have several outside companies that we create payroll files for that send me their file specs and I do not see a way in Crystal to tell it what position to start a field...

I am using the following formula to compute a running total at the Group Footer level. WhilePrintingRecords; numberVar fit_runtotal :=fit_runtotal + {@gross_adj} The number calculates fine and the last GF1 line has the correct total. However I would like to have the last GF1 line total...