We are upgrading PeopleSoft 7.5 to 8.4 and Crystal Reports 6 to 8.5. When going through the reports to verify the database to make sure all reports are still compatible and ready for testing, I get two errors that I can't seem to work out.
Error 1: 'Bind value to large.'
I believe it has to do with the date field in the query. The query uses a date prompt.
Error 2: 'Blob or memo field cannot be used in a formula'
The fields are text254 and are of mixed character type. I have tried using a formula "length({text254})" to test but recieve an error. I've also tried replacing the field in the query with a SQL Expression of type character 254 but still shows up in Crystal as a memo field.
Any help would be GREATLY appreciated!
Thanks in advance!
Error 1: 'Bind value to large.'
I believe it has to do with the date field in the query. The query uses a date prompt.
Error 2: 'Blob or memo field cannot be used in a formula'
The fields are text254 and are of mixed character type. I have tried using a formula "length({text254})" to test but recieve an error. I've also tried replacing the field in the query with a SQL Expression of type character 254 but still shows up in Crystal as a memo field.
Any help would be GREATLY appreciated!
Thanks in advance!