none
Having issues with an expression in Visual Studio 2005 RRS feed

  • Question

  • Hello,

    I'm trying to run the following expression in a textbox in my Visual Studio report:

    =COUNT(IIF(Fields!APPROVED.Value = "No",CDbl(Fields!SalesTotal.Value),CDbl(0)))

    It doesn't error out, but it produces the same result value as this:

    =COUNT(Fields!CUSTNMBR.Value)

    I'm trying to get a total count for only the "Approved value equals NO"

    Any ideas?

    Oddly, I'm also doing these slighty different expressions in the same report which are working fine:

    =SUM(IIF(Fields!APPROVED.Value = "No",CDbl(Fields!SalesTotal.Value),CDbl(0)))
    =SUM(IIF(Fields!APPROVED.Value = "No",CDbl(Fields!QtyInvoiced.Value),CDbl(0)))

    • Moved by Bill_Stewart Thursday, November 1, 2012 2:20 PM Move to more appropriate forum (From:The Official Scripting Guys Forum!)
    • Moved by Mark Liu-lxf Friday, November 2, 2012 2:27 AM report issue (From:Visual Basic General)
    Thursday, November 1, 2012 3:25 AM

All replies

  • This is the incorrect forum for VB.Net questions.  Moderators, please move?

    Grant Ward, a.k.a. Bigteddy

    Thursday, November 1, 2012 5:07 AM