- Rounding/truncating values in Reports
- Posted by WiLLerZ on November 3rd, 2006
I am building a custom report which gives a summary of the number of
accounts, leads and opportunities each manager has, and a break down of
the opportunities and leads (like the Account Overview report). In the
opportunity and lead summary sections, I want to display the top 5 by
price, and display the total estimated value, total weighted value and
average estimated probability (just like the Account Overview). I have
created all this and it's fine, except for the fact that it displays
the monetry values with no dollar sign and 1 decimal place, and the
probability value has 13 decimal places - not so nice to look at. Does
anyone know how I can modify the SQL query to round these numbers
appropriately (and maybe even chuck some dollar signs in)?
- Posted by Gunady on November 3rd, 2006
Are you using Reporting Services? If it is, you can put some Format in
the textbox, just right click the textbox and then properties, Check
for the Format tab, there is textbox for you to specify the format. If
you are using custom web (ASPX), maybe you can try to convert to
decimal, and then use ToString("N2").
Gunady
WiLLerZ wrote:
- Posted by WiLLerZ on November 5th, 2006
Ah thanks for that - so obvious now I know!
Gunady wrote:
