General information
Category:
Reports & Report designer
David,
I use left-justified mono-spaced output for financial reports.
The only other possibility is to drop several controls on the report band for each figure, which is more work than I care to do, but might go like this:
1. A "$" sign
2. An open "(" with print when MyTable.MyValue < 0
3. The value, ABS(MyTable.MyValue)
4. A close ")" also with print when MyTable.MyValue < 0
This would get you out of the mono-spaced font, but of course makes laying out reports a big headeache.
>
>Kenneth, your little UDF works great...for left justified fields. Turns out I'd like to right justify the field of interest. Apparently, VFP is just as happy as a clam to squeeze white space out of the right side of character strings to be printed and right justified. And it does just that to the output of your UDF. (At least I assume that's what's happening since the ')' of the negative values aligns with the LSD of the positive values ... but only when I right justify).
>
>Do you know of a character that prints as a space but is not interpreted as 'whitespace' by VFP.
Previous
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