Coderock

--------------------------------
link hover image

Crystal Reports: Formula editor window disappears

Frontpage calendar image January 7, 2016

If you are using a dual monitor or changing your monitor resolution, it is possible to ‘lose’ your Formula Editor. For Version 12, close Crystal Reports first and then follow these steps: Click the Start button and select “RUN” Type “Regedit” and Click “OK” Find the Registry key: HKEY_CURRENT_USERSoftwareBusiness ObjectsSuite 12.0 Crystal ReportsFormula Workshop Change […]

link hover image

Crystal Reports: How do I remove a “default” value for a parameter

Frontpage calendar image April 15, 2013

If you want to remove a “default” value for a parameter in crystal report you have to uncheck: File -> Options -> Reporting -> Save Data With Report.

link hover image

Crystal Reports: How to send a crystal report directly to printer by using ASP

Frontpage calendar image April 12, 2013

To send a crystal report directly to printer you must use property Destination = 1(to printer). This will send output directly to printer without preview screen.

link hover image

Crystal Reports: Special Character don’t show

Frontpage calendar image April 10, 2013

If your report don’t display special characters you must cast the string to nvarchar in your store procedure : wrong: P.FirstName +’ ‘ +P.LastName As PersonName Good: CAST(P.FirstName +’ ‘ +P.LastName AS NVARCHAR(150)) As PersonName

link hover image

Crystal Report: Remove formula value when no data

Frontpage calendar image April 9, 2013

If you want to remove formula value when you don’t have data: you can try to check if the object has empty string as well, by using trim() If IsNull({objectName}) or (trim({objectName}) =”” ) then x := “Fixed Text” Else x :={objectName}