Random Thoughts By Mr 337

Hi All,

I was working on a web form project with SSRS embedded for a couple reports for the end user. In the MS SQL DB a table had a column data type as money.

When data was brought from the SQL Server and into the report and rendered the dollar amounts had two extra trailing zeros. For example: Grand Total: 24.82000

Weird I though, so after some googling came across a format that will help.

If displaying in a text box right click on the text box and go properties (if I remember right, it also might be called “Value”).

There should be something already there is the textbox is getting populated, something like =Dataset2!Fields.Total

Simple add this around the existing code

syntax:

So for my purposes I need two places right of the decimal for US currency

The output was Grand Total: $24.82

Viola

This entry was posted on Saturday, March 22nd, 2008 at 5:28 pm and is filed under Microsoft, Programming. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.