Crystal Report - Tips

TIPS HERE :

• Don't use tables directly in Database Expert instead use 'Add Command' Option in Database Expert since it will improve the performance of the report.

• To pass a parameter in a query, use '{?parameterName}' and add the same parameter in "insert parameter" dialog box.

• When exporting a report that contains strings encoded in a particular character set (for example, German) to Text format on a system using a different code page than that set (for example, Japanese, or simplified Chinese), the export can enter into an infinite loop. The cause was that some characters were misinterpreted as the lead byte of a double byte character. This would result in the export to loop on the character following the misinterpreted one. Hence to avoid this, enable UNICODE instead of ASCII during the installation of Database and Crystal Reports server.
  

Thanks
A.T.J