General information
Category:
Reports & Report designer
Title:
String with constant length for digits
Environment versions
Network:
Windows 2003 Server
Trying to show a band like this in the group footer of a report.
I'm using a temp table with a memo field to store the values using:-
padr(alltrim(cheque_no),10," ")+" "+dtoc(date())+" "+padl(alltrim(str(number),10,2),10," ") to try to get the following result.
cheque number Date Amount
ABC123456 01-01-2006 390.00
CDE23456 01-02-2006 1350.00
and more...
However, I always end up with
cheque number Date Amount
ABC123456 01-01-2006 390.00
CDE23456 01-02-2006 1350.00
where the numbers column can never be aligned.
Is there something I'm missing out here?
Thanks in advance
Yau
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only