locked
Report Builder 2.0 RRS feed

  • Question

  • I built a simple report that would display some values from CRM.
    I noticed something that I need you guys to help me with

    for example ,

    Original value is 123.63
    Current Displayed in Reoprt builder is 124.00

    I want to display the orginal value without rounding. how to do this???

    hussain
    Tuesday, November 24, 2009 7:54 AM

Answers

  • I guess you need to edit the report in SSRS 2005/2008 (visual studio) and update relevant textbox 's format code to

    =First(Fields!CurrencyFormat_2_Precision.Value, "DSNumberAndCurrencyInfo")

    this will be apperance of decimal value to 2 decimal place...
    • Marked as answer by Hussain Saffar Tuesday, November 24, 2009 3:21 PM
    Tuesday, November 24, 2009 9:19 AM

All replies

  • This is likely to be due the formatting of the element (TextBox etc) in Report Builder. Change the Format property to e.g. N2 (N indicates it's a number, and 2 is the number of decimal places)
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Tuesday, November 24, 2009 9:11 AM
    Moderator
  • I guess you need to edit the report in SSRS 2005/2008 (visual studio) and update relevant textbox 's format code to

    =First(Fields!CurrencyFormat_2_Precision.Value, "DSNumberAndCurrencyInfo")

    this will be apperance of decimal value to 2 decimal place...
    • Marked as answer by Hussain Saffar Tuesday, November 24, 2009 3:21 PM
    Tuesday, November 24, 2009 9:19 AM
  • yes, i'm following that format but without ay luck


    hussain
    Tuesday, November 24, 2009 9:37 AM
  • thank you
    hussain
    Tuesday, November 24, 2009 3:21 PM