Crystal XI and VARCHAR(MAX), A.K.A. "memo"

Found a suprising thing. When attempting to use a VARCHAR(MAX), a.k.a. "memo" field with the SQL Server Native driver--Crystal XI won't recognize it correctly. It want brings it in as a String(255).

Had to change the ODBC driver used back to "SQL Server", i.e., pre-2005 and it will recognize.

Use suppressed RH for 'scratchpad' in Crystal Reports

When copying info from report to report -- I like to have a 'scratchpad' area. A placed where I can cut/copy/paste items from one report to another without effecting the report functionality.

To accomplish i create an addtional RH section right-click check 'suppress'.

Find Results(alt+r in CR Formula Editor)

When using the Crystal Reports formula editor -- you can use alt+r to bring up a cross reference of the formula within the report.

To use click on a single formula from the field-tree, right-click ~ find results to find all references within the report.

Goal: Look for repetition ~ duplication & eliminate...

Principle observed from Pragmattic Programming: DRY (don't repeat yourself).