Use multiple ReportItems in footer expression in RDLC Report RRS feed

  • Question

  • I have created rdlc report that have two column, which is Rate and Amount. In footer, I want to make sum of amount base on rate. I meant, I want to count the amount value if rate value == 0.45%.

    I have try to use this code : =IIf((ReportItems!Rate.Value like "0*"), Sum(ReportItems!Amount.Value), Nothing) but it was an error :

    An expression in a page header or footer can refer to only one report item.

    Tuesday, November 8, 2016 9:58 AM