block filter based on another block

building reports webintelligence
1

I have two blocks in a report.
One shows sales information for a salesperson.
I’m using an input control to select the salesperson.

I need the second block to show the sales for all of the other sales people in the same division as the selected sales person.

Is there anyway to filter that block based on the first…
For example
[Division] = [block1].[Divison]
?

Thanks in advance for your help.

esiegel (BOB member since 2009-11-09)

2

I’m not sure if I understand your question but…Why don’t you run a second query in the same report to try to place a filter asking for information of ALL the salesperson EXCEPT for the one you laready have in the first.

katullus :us: (BOB member since 2009-08-21)

3

in the query (or queries) the information for ALL sales people is pulled.
the Input Control (new in SP2) basically creates a report level filter that can be applied to a report or specific blocks.

I’m trying to apply that filter to one block…and a different…albeit related filter to another block.

esiegel (BOB member since 2009-11-09)

4

OK…
so I have the input control that selects the Salesperson.
I also made a block that shows the Salesperson’s division into an input control (right click on it and define as input control).

This allows me to filter the second block based on the division displayed in the first block. (yippeeee).

The only problem is that, after selecting the salesperson (first input control), the user has to click on the first block (second input control) to update the second block.

Is there anyway to auto trigger the update of the second input control?

esiegel (BOB member since 2009-11-09)