FRx SP10 and CS Currency Rounding on the First Row
I just found this workaround for the CS currency rounding issue. Found it on the FRx forum at microsoft.public.com. By default, FRx adds the currency format to the 1st row of every report. SP10 has not been allowing the rows with CS to round properly.
The commenter was wondering why some of her reports rounded on the 1st row and some did not. I have wondered the same thing! I haven’t tested this yet but wanted to get it out. Here you go:
“I discovered one difference that apparently changes how the 1st row currency symbol and the whole dollar rounding from the catalog affects the report. If the 1st line of the row is blank or has a DES format code, the 1st row of data rounds correctly with the currency symbol. If the 1st line of the row contains data it gives the decimal places and needs the workaround and will show $0 even if “Display blanks for zero amounts” is checked.
So I just added a blank NP line in the row and my first line now includes the $ and rounds to the whole dollar. Don’t know why that works but I’m thankful it does!”
I’m thankful that the commenter shared her discovery!
If you want to know more about the currency rounding issue, please see my post at FRx SP10: The Good, The Bad, and the Ugly.
Go to company>>internation format. I believe the CS is using this format. I changed the format to not have a decimal and it got me what I wanted.
Sorry, This is more correct.
Go to company>>international format. Change the amount with currency symbol format. I believe the CS is using this format. I changed the format to not have a decimal and it got me what I wanted.