none
how to display zero ( null ) value on the report textboxes ? RRS feed

  • Question

  • hi,

     

    when we have a sum queries, some times it returns zero valu but the report won't display any vakue in this csse, so how we can do that ?

    Thursday, July 26, 2007 9:54 AM

All replies

  • Hi.
    Maybe this will work. (I'm using .rdlc)
    Add textxbox and then in the textbox gift expression like IIf(<DataSum>Is Null,0,<DataSum>)
    move the textbox into  desireable position.


    Thursday, July 26, 2007 10:21 AM
  • thanx, i inderstand that i should use this expression with all the textboxes on the report ? if it is , it is very difficult.

     

    Thursday, July 26, 2007 12:42 PM
  •  

    up
    Friday, July 27, 2007 6:10 PM