Graph Issue with 2 DP's

building reports desktopintelligence
1

hi, I have a graphical report with two data providers
x axis - interval
Y axis - usage
Z axis - date

I have to calculate and display the total usage curves in graph for each date.
Data provider A generates 4 different dates in Date column - 06/06/2004
06/05/2004
06/04/2004
06/03/2004

Data provider B generates only one Date Column - 06/06/2004

I’m able to display the 5 Total Usage Curves for each Date from both data providers, but when i insert a legend its displaying 8 lines (It should display only 5 lines (4 from data provider A and 1 from data provider B). I’m not able to edit the Legend, Is there anyway to come out of this problem.
Any help appreciated.
Thanks in Advance,
–Raj. :?

ellis27 :us: (BOB member since 2004-06-22)

2

Hi

Were you able to find a solution to you problem?

I have a similar problem and I think it is because it forms some kind of a cartesian product, because it does not link the providers perfectly.
If you look at a result table, you also find 8 rows very likely.

Wolfgang

wprankl :de: (BOB member since 2005-04-20)

3

It’s not a bug. Data providers link, they do not join? The link results in a full-outer join between the 2 data providers. That’s how it works. That’s how it has always worked.

You can write formulas that get rid of the extras by implementing “Not Isnull” within a derived formula.

Do a search for Not Isnull* and you’ll get some ideas.

Steve Krandel :us: (BOB member since 2002-06-25)