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)