Post reply

How to Calculate specific cell (with expr) total in SSRS ???

  • May 29, 2014 at 10:51 am

    #308569

    i use sql server 2012 and visual studio 2010.

    I want to just calculate only two cells (where it's a red text in a picture)

    1. win total its' sum all win.

    2. Bet Amount win it's total amount money of win.

    win it's bit (False/True), so for get count i use this code:

    =Sum(IIF(Fields!Win.Value, 1, 0)).ToString()

    Bet Amount Win it's money cell and it's sum from this code:

    =SUM (fields!BetAmount.Value * IIF(Fields!Win.Value, 1, 0))

    if you can tell me who to do it, i try make a sum col in a date line

    (where it's dark grey line, under a blue)

  • May 30, 2014 at 2:39 am

    #1717686

    Does anyone know this?

  • May 30, 2014 at 9:52 am

    #1717857

    Well, it seems like you should just be able to copy and paste the code that you have for the detail rows into the header row, and it will work. Is that the same as what you posted (which seems fine), and have you tried that already? If so, what happens?

    Also, feel free to consider posting the RDL with some dummy data in the data set so we can see exactly what's going on.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply