Rounding/truncating values in Reports

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)?

Gunady
Fri Nov 03 04:00:35 CST 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:
> 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)?

WiLLerZ
Sun Nov 05 17:34:07 CST 2006

Ah thanks for that - so obvious now I know!

Gunady wrote:
> 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:
> > 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)?