Count function using another Data Provider

building reports desktopintelligence
1

Hi,
I need to calculate the total no. of employees which match the prompt filter except two prompts. But I need to have the result which match all the propmts. I used another data provider to calculate the total count of employees which matches all except two prompts . But when i drag the varible in the column in the table . It’s creating one extra row. When i unlink it, it is gone . But everytime i need to unlink it . Can anyone tell what is the other way …?

pks (BOB member since 2004-07-11)

2

Instead of building conditions on the query to filter, I would bring it all back values and then create report variables as flags to specify what is counted or filtered.

scott copeland (BOB member since 2002-08-15)

3

Can u please tell me in detail.? What condition i have to apply. Since i am doing the count based on the prompts. How can i set it the report level?

pks (BOB member since 2004-07-11)