Knowledge Base

Reports exported to Excel cuts of first '0' of any result starting with 0

Hint Ref: 020904210005
Hint Date: 21/04/2009

Hint Details:

ISSUE:

 

In some cases, when a report is printed as an Excel document, if there's any result that starts with the number zero, that zero will not appear on the spreadsheet but the rest of the result will.


SOLUTION:

If you use a dbmemo rather than a dbtext for the field in question and also make the selection a string in the SQL, this seems to do it.


(Please Note: This Procedure can be destructive and should only be used by Advanced Users.  RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command.  Responsibility resides solely with the user.  

IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)