Problem with sum's at grouping RRS feed

  • Question

  • Hello,

    Im using Microsof reports to display some information. I'm hiding some rows with visibility statement - =IIf(Fields!ar_sand_plius.Value = 0, True, False)

    Now i need to do Grouping and sum only visible rows, i tried this: =Sum(IIf(Fields!ar_sand_plius.Value = 0, Fields!suma.Value, 0))

    but this didnt work, it gives me back #Error everytime when in group are some hidden rows, if at grouping is no hidden rows it sums well.
    Tuesday, October 27, 2009 6:31 AM

All replies

  • Hi,

    Try to use the textboxes name of which you have draged and droped the fields rather fileld names, So the sum function will add only the values of the textboxs not the fields

    like ReportItems!txtbox1.value

    -Raja Sekhar K
    Tuesday, October 27, 2009 8:58 AM
  • it's not working with me i have als try

    like ReportItems!txtbox1.value

    please help

    Sunday, July 18, 2010 12:17 PM