Filter on two table of a report, to get connected results

Can some one please tell me if this is possible in BO and if it is then how do I do it.

I have two tables on my report. The first table is “Names” and the second table is “Net Salary for all the Names”. Is there a way to filter table one on which it filters and shows only the salary for that one filtered person in table two.

For Example if I were to Filter the Names table for “JOHN” then in the second table of the report, I should see “$ 90,000.00” in the salary table, which is what JOHN makes an year.

Thanks and Reagrds,


bo_reporter (BOB member since 2004-02-21)

Does your second table contain names as well? If so try using a global filter.

Are you using multiple data providers?


Andreas :de: (BOB member since 2002-06-20)

Hello Andreas,

Yes! I am using Multiple Data Providers, but from one universe.

Can you please tell me if I can build a prompt like thing in the universe to this effect.

As usual thanks very much Andreas for the speedy answer.

Thanks and Regards,


bo_reporter (BOB member since 2004-02-21)