none
Report Viewer Expression Problem RRS feed

  • Question

  • I have created a report using Report Viewer in Visual Studio 2015 and VB.Net. My problem is trying to get an expression that I have entered into one of the TextBoxes to give me the value that I am looking for. Here is the expression I have created:

    =IIf(Fields!DateSold.Value>=#01/01/2015#,RunningValue(fields!CostFed.value,

    Sum,Nothing),0)

    I want to get a running total of the Fields!CostFed.Value only if the Fields!DateSold.Value is greater of equal to #01/01/2015#. There are three records in the database, and the first two have DateSold values that are 3/11/2015, 6/11/2015 and the last one is null (no date). I am getting the sum of all of the CostFed fields, even the one where the DateSold is Null.

    What am I doing wrong with my formula?

    Thanks for your help.


    BobV365

    Friday, November 13, 2015 11:10 PM

All replies

  • Hi Robert,

    Seems this issue is related to ReportViewer control, I will help move it to that forum for effective response.

    Thank you for understanding.

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, November 16, 2015 5:55 AM