Home Forums Reporting Services SSRS 2014 Exporting to Excel using 2014 SSRS not calculating correctly total seems to double RE: Exporting to Excel using 2014 SSRS not calculating correctly total seems to double

  • In general, you should let grouping in SSRS take care of calculating totals.  Using custom code should be avoided for that kind of purpose.   Better yet, calculate your totals in your query for your dataset, and then all you need to do is display rows.   Alternatively, a matrix or tablix can do the grouping work for you and all you need to select is the raw data.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)