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