In a different thread
http://www.lantica.com/Forum3/cgi-bin/yabb2/YaBB.pl?num=1195161311 I got some help designing a freeform report, and it's coming along well, and I've used the techniques Erika suggested here
http://www.lantica.com/Forum3/cgi-bin/yabb2/YaBB.pl?num=1195159451 to make a command button that opens it in Internet Explorer so it can be emailed. Here's a sample of my current report output:
http://www.jamiara.com/freeform-in-progress.htm.
Here's a sample of some of the code I'm using. In this case, it prints the Forklift information portion of our invoices:
Var vF1TotalString as String
Var vF2TotalString as String
Var vF3TotalString as String
Var vForkTotalString as String
Var vF1Total as Money
Var vF2Total as Money
Var vF3Total as Money
Var vForkTotal as Money
vF1Total = Fork_1_Total
vF2Total = Fork_2_Total
vF3Total = Fork_3_Total
vForkTotal = Forklift_Total
IF vF1Total <> 0 THEN vF1TotalString = ".....$" + @Str(@Decimals(vF1Total,2))
IF vF1Total <> 0 THEN vF2TotalString = ".....$" + @Str(@Decimals(vF2Total,2))
IF vF1Total <> 0 THEN vF3TotalString = ".....$" + @Str(@Decimals(vF3Total,2))
IF vForkTotal <> 0 THEN vForkTotalString = "..........$" + @Str(@Decimals(vForkTotal,2))
IF (Fork_1_Total <> 0 or not @IsBlank(Fork_1))
THEN
{
Fork_Info = Fork_1 + s5spaces + vF1TotalString + @NewLine()
}
IF (Fork_2_Total <> 0 or not @IsBlank(Fork_3))
THEN
{
Fork_Info = Fork_Info + Fork_2 + s5spaces + vF2TotalString + @NewLine()
}
IF (Fork_3_Total <> 0 or not @IsBlank(Fork_3))
THEN
{
Fork_Info = Fork_Info + Fork_3 + s5spaces + vF3TotalString + @NewLine()
}
Fork_Info = Fork_Info + s10spaces + Forklift_charges_label + vForkTotalString
The static variables in Global code that I'm using for spacing are:
Stat s5spaces as string
Stat s10spaces as string
s5spaces = @Text(5, " ")
s10spaces = @Text(10, " ")
My next question is, is there a way to "pad" the concatenated elements so that the money figures right-align, perhaps a better way to be using " "?