The TenantIndividual Report only returns the Hexadecimal format card number.
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.
- 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