Post reply

How do I group multiple Tablix Controls together???

  • July 17, 2012 at 11:58 am

    #276058

    I have a report that has 3 tablix controls using 3 different datasets. They are of the same data types and I need to group these 3 datasets together and create a Grand Total at the bottom of the report with the sum of the 3 datasets in the Grand Total.

    Anyone have any ideas the best approach?

    thanks in advance for any help,

  • July 19, 2012 at 7:17 am

    #1514828

    this might help you..

    http://www.sqlservercentral.com/Forums/Topic1328723-150-1.aspx

  • July 19, 2012 at 8:57 am

    #1514908

    Thanks for the response on this it was helpful. I will probably use a method to capture the values and put them in another dataset that would have the totals like a sproc or something that would run against the 3 datasets.

    Would you just create a tablix to hold the total values and put that at the bottom of the report?

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

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