April 22, 2011 at 7:37 am
First post here so forgive me if it's in the wrong place.
In a textbox I have the following: =FormatCurrency(Fields!Cost.Value,0)
It formats and displays the values correctly. $1,234,567
When exporting to Excel, there are no problems.
When exporting to PDF, the dollar sign is at the end of the value. 1,234,567$ Has anyone experienced this?
Thanks,
Anthony
April 25, 2011 at 12:56 pm
Don't know if this will help. Try putting C0 in the Format property of the textbox.
SSRS has a number of shorthand number formatting codes. C = currency, P = Percentage, N = generic number. The 0 (zero) indicates the number of decimals to display. In the case above C0 indicates Currency without anything after the decimal place. There is a lot more you can do with number formats, but these shorthand codes will cover most of your daily needs.
April 26, 2011 at 4:47 am
Thanks for replying Daniel.
I changed the expression and set the formatting in the textbox properties. This displayed the correct format in SSRS but not when exporting to PDF.
Both methods yield the same results. The format is correct in SSRS and printing to PDF, however when exporting to PDF, the dollar sign is on the wrong end of the amount.
April 26, 2011 at 4:59 am
Figured it out.
I changed the text direction to LTR. It now displays correctly when exported to PDF.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply