I was not able to find any other solution other than using the Mid(str, start, length) function. This is not rotating the string at 90 degrees as the customer wanted but at least it is printing 1 digit per line.
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 1,1) + chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 2, 1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 3, 1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 4,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 5,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 6,1) + chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 7,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 8,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 9,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 10,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 11,1) + chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 12,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 13,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 14,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 15,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 16,1) + chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 17,1)+ chr(10) +
Mid({RPT_CP_PRINT_COUPONS;1.Validation}, 18,1)
I'm still hoping that someone can come up with a better solution.
thanks all.
Rick