Crystal Reports report of Nsure Audit data shows garbage data instead of text

Crystal Reports report of Nsure Audit data shows garbage data instead of text.

Use the following query to both retrieve the data and translate it into readable text for Crystal Reports:

select FIELD_NAME,
convert(varchar(3072),convert(varbinary(3072),data)), *
from DATABSE_TABLE_NAME where eventid=YOUR_EVENT_ID

Crystal Reports XI (11) will not automatically display the nauditlog database "DATA" field since it's stored in a specific binary format. To convert the binary format to human readable ASCII text you must apply a special conversion algorithm.

To do so, create a new SQL Expression field in the report and add the following conversion algorithm expression into the dialog.

{fn CONVERT({fn CONVERT("NAUDITLOG"."DATA", varbinary(3072))}, varchar(3072))}

Save and close the SQL Expression field... Now you can use the new SQL Expression field to display/query the DATA field just like any select field from the NAUDITLOG database. You may also consider reducing the max size of 3072 bytes in order to increase the performance of the report query but be sure the data you are looking for is within the range you set.

The data is logged in the database in binary format. It will need to be decoded to be human-readable.
The reporting tools in iManager and Nsure Audit Report will automatically perform the translation.

Formerly known as TID# 10095649