Add Custom Log Report - Advanced Topic - Report Design - Tablix Field Formatting

Currency or Number Format

1. Select the currency or number field in the tablix control then click the Properties icon on the right.
   
   
   
   
2. Expand the Basic Setting section and click the three horizontal dot icon in the Format property field.
   
   
   
   
3. Change the Type to Number or Currency then set the number of Decimal Places.
   
   
   
   
4. Optional: Check the 'Use 1000 Separator (,)'.
5. Click the 'OK' button in the popup form.
6. Click the 'Save Report' link at the top to save these changes.

Date Format

1. Select the date field in the tablix control then click the Properties icon on the right.
   
   
   
   
2. Expand the Basic Setting section and enter dd-mmm-yyyy in the Format property field.
   
   
   
   
3. Optional: Click the three horizontal dot icon in the Format property field to choose a different date format.
   
   
   
   
   1. In the popup form, change the Type to Date.
   2. Select the Date Format from the drop-down.
   3. Click the 'OK' button.
4. Click the 'Save Report' link at the top to save these changes.