Message
From
29/11/2006 11:43:55
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
String with constant length for digits
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01173334
Message ID:
01173334
Views:
59
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
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