I'm attempting to Trim some fields, but when I run the report to export as an Excel 2007 Data file, I receive an error. This is significant because due to formatting restrictions, I need to run this file as Excel 2007 Data. The file does run in Excel 2007, HTML, PDF, etc format.
I have attempted:
trim ([Customer First Name (CFMA)])
trim (trailing ' ',[Customer First Name (CFMA)])
trim (' ',[Customer First Name (CFMA)])
Each results in the following error:
RSV-SRV-0040
The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence.
Any thoughts on another way to trim this field and still use Excel 2007 Data as the output format?
This might be an obvious question, but have you verified that it's that field that's causing the problem? If you create a simple query with trim ([Customer First Name (CFMA)]) do you get the same error?