Post reply

SSRS 2008 adding values from different data sets

  • August 25, 2009 at 1:46 pm

    #209962

    SSRS 2008

    Hi,

    I've got a report that has 3 MDX datasets all of which have the same columns, but have different complex logic.

    The 3 datasets fill 3 tablixs that are the same format.

    I need to add up the totals of the tablixes, and was hoping to add the totals of the matrixes, but alas reporting services doesn't seem to be able to add across different scopes as i've tried using ReportItems.

    Any ideas?

    Thanks

  • August 26, 2009 at 6:48 pm

    #1045278

    try using SUM function with dataset name.

  • August 27, 2009 at 8:22 am

    #1045564

    Hi,

    I had same issue but i was using table data region...what i did to overcome this issue, changed my sql using differnt joins to combine all the datasets data into one dataset.

    and one more thing is i used normal SQL not MDX

    i dont know this will help or not

    Bhaskar

  • September 24, 2010 at 12:45 am

    #1226730

    Hi, you can reference report items like cells in a tablix using something like !reportitems("item_name") I'm writing on my phone so cannot check the exact format right now.

    So if you create a subtotal item in your tablixes you can reference them in a simple expression.

    If you get stuck I'll post more detail when I'm back on a pc.

    Hth

    John

    Assumption is the mother of all F***ups

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

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