The $ must appears only on certain total levels and has to be in the same position in the column regardless of the value for financial reporting. In other words, I don't want the $ to float next the most significant digit in the value. See the example below from Excel. Using an IIF statement I can concatenate the $ to the string when it is a certain group level. However, I have tried many various formatting strings but can't find one that results in a fixed number of characters so that the $ will always appears in the same position in the column.
Anyone have a way to do this?
I did get this to work by adding a column to the grouping. That somehow causes the heading size to increase (?) and takes much more time than coding a format code in an expression (I have many reports to do).
Can you try something like this in your field's expression:
="$" & Space(30 - len(Fields!Total.Value)) & Fields!Total.Value
The 30 in my example would have to be higher than the maximum number of digits in your Total field. This will put spaces between the $ and the actual number you are showing, but only enough to make the $ symbols align.
Hope this helps.
Jarret
|||This is close, but the proportional font keeps the $ from lining up.
I am not a VB programmer so I have a little trouble finding the appropriate string and format functions.
Thanks for your reply.
|||Could you change to a fixed-width font so that it would line up?
Or, you could add a column to the left of the field that has the $ symbol in it, but only for the group header and footer. This way, it would always line up.
Jarret
|||I did the add a column and it causes the group headers to grow and be ugly. I am hoping for a solution where I can code something in the expression. If not, I may have someone code me a little VB routine to use.
Thanks.
