Crystal Reports XI.
I'm having problems exporting a large amount of data (i.e. many fields) from Crystal to a text file. I created a formula to assemble all of the required fields, which must be fixed length to match a mainframe system (formula is below). Each sub-formula makes the corresponding data field the correct size (e.g. pad the last name with spaces to make sure it's 20 characters).
I think there are just way too many characters for Crystal to handle. When it's placed on the detail line nothing gets displayed in the preview pane, and nothing gets exported to the text file either. If I start to remove fields (i.e. comment them out of the formula below) the data appears after commenting out Addr2 to the last SPACE at the end.
I've tried a bunch of things with page setup and font but no luck (including some suggestions from similar questions/answers posted at Tek-Tips). Not sure if there is a solution but I'm out of ideas, so any suggestions or comments will be appreciated.
Thanks.
I'm having problems exporting a large amount of data (i.e. many fields) from Crystal to a text file. I created a formula to assemble all of the required fields, which must be fixed length to match a mainframe system (formula is below). Each sub-formula makes the corresponding data field the correct size (e.g. pad the last name with spaces to make sure it's 20 characters).
I think there are just way too many characters for Crystal to handle. When it's placed on the detail line nothing gets displayed in the preview pane, and nothing gets exported to the text file either. If I start to remove fields (i.e. comment them out of the formula below) the data appears after commenting out Addr2 to the last SPACE at the end.
I've tried a bunch of things with page setup and font but no luck (including some suggestions from similar questions/answers posted at Tek-Tips). Not sure if there is a solution but I'm out of ideas, so any suggestions or comments will be appreciated.
Thanks.
Code:
// Format all of the fields required for the report and combine them into
// one field for printing so when the report output gets exported to a
// comma delimited Text file it will match the caller file format requirements.
{@f_SSN} + "," + // SSN PIC X(10) VALUE SPACES
space(10) + "," + // PAYROLL-EID PIC X(10) VALUE SPACES
space(10) + "," + // RETIRE-EID PIC X(10) VALUE SPACES
space(04) + "," + // PIN PIC X(04) VALUE SPACES
space(01) + "," + // BARG-UNIT PIC X(01) VALUE SPACES
space(06) + "," + // DEPT-CODE PIC X(06) VALUE SPACES
space(01) + "," + // BENEFITED PIC X(01) VALUE SPACES
space(04) + "," + // EMP-STAT PIC X(04) VALUE SPACES
space(08) + "," + // HIRE-DATE PIC X(08) VALUE SPACES
space(01) + "," + // CITY-SDDPC-CD PIC X(01) VALUE SPACES
{@f_LastName} + "," + // LAST-NAME PIC X(20) VALUE SPACES
{@f_FirstName} + "," + // FIRST-NAME PIC X(15) VALUE SPACES
space(03) + "," + // SUFFIX-NAME PIC X(03) VALUE SPACES
{@f_MiddleInitial} + "," + // INIT-NAME PIC X(01) VALUE SPACES
space(04) + "," + // TS-LEVEL PIC X(04) VALUE SPACES
space(10) + "," + // RETIRE-PLAN-ID PIC X(10) VALUE SPACES
space(01) + "," + // 401K-CURR-CONT PIC X VALUE SPACES
space(01) + "," + // 401K-BAL-IND PIC X VALUE SPACES
space(01) + "," + // SPSP-CURR-CONT PIC X VALUE SPACES
space(01) + "," + // SPSP-BAL-IND PIC X VALUE SPACES
space(01) + "," + // SPSP-M-CURR-CONT PIC X VALUE SPACES
space(01) + "," + // SPSP-M-BAL-IND PIC X VALUE SPACES
space(01) + "," + // SPSP-H-CURR-CONT PIC X VALUE SPACES
space(01) + "," + // SPSP-H-BAL-IND PIC X VALUE SPACES
{@f_Addr1} + "," + // ADDRESS-LINE-1 PIC X(30) VALUE SPACES
{@f_Addr2} + "," + // ADDRESS-LINE-2 PIC X(30) VALUE SPACES
{@f_Addr3} + "," + // ADDRESS-LINE-3 PIC X(30) VALUE SPACES
{@f_City} + "," + // CITY PIC X(30) VALUE SPACES
{@f_State} + "," + // STATE PIC X(02) VALUE SPACES
{@f_ZipCode} + "," + // ZIP PIC X(09) VALUE SPACES
space(57) // FILLER PIC X(57) VALUE SPACES