Using Lookup Function to Bridge Datasets in Report Builder

  • Comments posted to this topic are about the item Using Lookup Function to Bridge Datasets in Report Builder

  • hi nice article.

    I have a issue which this looks like it may be about to solve. What I need to do in my lookup dataset though is group on two fields and then aggregate a third - i.e.

    Group1, TransactionType SUM(my Value)

    the purpose of this dataset is to say the total of Group1, TransactionType total is x.

    in the main report/data set, I would then include every transaction where the sum of the group1 and transcationType total is more than x?

    eg. report

    group transactionType groupTotalValue TxValue

    home Buy 10 2

    home exchange 10 7

    home sell 10 1

    so the sum of the TxValue would match groupTotalValue.

    the complex bit is that I want to filter the report by on groupTotalValue > 10 using the lookup dataset. (i hope that makes sense)

    How would I do that as I keep reading that you can group in a dataset?

    any help would be appreciated

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

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

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