locked
expression in Report view in asp.net RRS feed

  • Question

  • User-1640542475 posted

    Hi 

    I have problem in Report viewer.  I am using the expression to filter the value. I explain my scenario.

    I want sum the amount for particular category. I have student database. I need the sum the paid amount for exam fee only.

    =SUM(Fields!Amount.Value, "DataSet1") . It sums all amount. But I need to sum EXAM FEE only. Please help me how to do this

    Thank  you

    Maideen

    Tuesday, September 3, 2013 9:21 PM

Answers

  • User-67082742 posted

    Hi,

    You may use  =Sum(Lookup("EXAM FEE",UCase(Fields!FeeType.value),Fields!Amount.Value,"DataSet1"))

    Here I assume Fields!FeeType.Value is the field that contains the fees type like "Exam Fee" etc.

    Thanks,

    Ab

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, September 5, 2013 5:28 AM

All replies

  • User22205941 posted

    you may try to use Immediate if 'IIF'

    =SUM( Iff(ur_condition,truefiled_value,falsefield_value),"Dataset1")

    Its my idea. Try this.

    Wednesday, September 4, 2013 3:34 AM
  • User-67082742 posted

    Hi,

    You may use  =Sum(Lookup("EXAM FEE",UCase(Fields!FeeType.value),Fields!Amount.Value,"DataSet1"))

    Here I assume Fields!FeeType.Value is the field that contains the fees type like "Exam Fee" etc.

    Thanks,

    Ab

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, September 5, 2013 5:28 AM
  • User-1640542475 posted

    Thank you lot

    Sunday, September 15, 2013 9:58 PM