Issue
The TenantIndividual Report only returns the Hexadecimal format card number.
Environment
SevenReports
Cause
I/NET does not store the Decimal format of a Card number, on the Hexadecimal format. To view this information you will need to create a custom Report Field.
Resolution
- In the SevenReports Design View, Right click on "SQL Expression Fields" and select "new"
- Name the Field
- Enter the following text: CONVERT(INT,CARDNUMBER)
- Save and Close
- Expand "SQL Expression Fields"
- Add the newly created Expression Field to your report
- Resize the Field to allow all of the data to be displayed
- Right Click on the Field select Format Field
- In the Number Tab Select "-1123"
- Click Ok
- Preview your report
