show the cross tab difference

[swiss2007]

I have completely 2 different datasources pcp1 and pcp2 and are not related
The data coming from pcp1 and pcp2 is most of the times same but not always.

I have a cross tab in the main report taht displays data from pcp1 and subreport
that displays data from pcp2

my goal is to find if there is any difference in the data from pcp1 and pcp2,
if there is any display the difference else display zero.


pcp1 data is as below

Country, mfdate, count
France, 2011/06/05, 2000
France, 2011/06/06, 300
Belgium, 2011/06/05, 1500
Belgium, 2011/06/06, 800


pcp1 cross tab is like

Rows: Country
Columns: mfdate
Summarized fields: sum of count

pcp1 cross tab output is

2011/06/05 2011/06/06
France 2000 300
Belgium 1500 800


pcp2 data is as below

Country, mfdate, count
France, 2011/06/05, 2000
France, 2011/06/06, 300
Belgium, 2011/06/05, 1500
Belgium, 2011/06/06, 900


Rows: Country
Columns: mfdate
Summarized fields: sum of count

2011/06/05 2011/06/06
France 2000 300
Belgium 1500 900


I would like to display the following in a seperate cross tab


2011/06/05 2011/06/06
France 0 0
Belgium 0 -100


If evrithing is same in pcp1 and pcp2 then I would like to display the following in a seperate cross tab


2011/06/05 2011/06/06
France 0 0
Belgium 0 0

Appreciate any help.

 

[Madawc]

If you can get the difference at detail-line level using a formula field, you should then be able to show it on a crosstab. Does that help?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP