BusinessObjects Board

Joining multiple Data provider on condition basis

building reports desktopintelligence
#1

Hi,

I do have one report built by 3 data providers i.e. DP1, DP2, DP3. I am able to join these and get the right data in place. Now customer wants to see only those data in report when either DP1 or DP2 is populated or both. It means, when DP1 & DP2 data is 0.00 OR Null Data should not be present even if DP3 is available.

Example

           Manager1   Manager2  Manager3	Mangaer4

“Amt From DP1” “38” “0” “21” “0”

“Amt From Dp2” “0” “0” “22” “31”

“Amt From Dp3” “31” “21” “0” “0”

In the above report Manager2 should not appear as DP1 and DP2 data is 0.

I would greatly appracited any suggestion.

Thanks,
-Manoj

045331 (BOB member since 2004-01-23)

#2

Interesting question, actually comes up quite frequently, thus the entry in the Reporter FAQ 8)

Dave Rathbun :us: (BOB member since 2002-06-06)