Format report data

Formatting options are available for Date and Money fields. Where applicable, follow the steps below to change how the value is displayed on the report.

  1. Select Reports > Builder.

  2. Use the Show All button to view all custom reports. Or use the Search Bar to further drill down your search. 

  3. Select the Report from the list. 

  4. Right click on the field after it has been dragged onto the Columns pane and select the desired option from the Format menu list.


Date Field Formats

Date fields allow you to display date and time serial numbers according to the type that you specify. Date fields that display time stamp information (hours, minutes, and seconds) along with the date information only display the first four formatting options for the date. The timestamp portion of the field will always show as "HH:MI:SS".

Money Field Formats

Money fields display monetary values and the default currency symbol with numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousand separator, and how you want to display negative numbers. 

Protected Health Information Field Formats

Social Security Numbers, by default, are masked preventing the first six digits from being viewed. All CollaborateMD standard reports protect Patient Health Information (PHI), however, you can choose to unmask the social security number (SSN) if needed.

  1. Right click on the field after it has been dragged onto the Columns pane and unselect the “Mask SSN” from the menu list to unmask the first 6 digits from the social security number.

    Important: In order to remain HIPAA compliant we strongly recommend keeping the SSN masked. Only users with the Patient Health Information permission can obtain the full value by accessing the patient's account.