merging 2 reports from 2 different servers

[sugu]

Hi,

I need to merge 2 seperate crystal reports(both uses the same templates but they r generated from different servers) and do a summation of their data for each field.

egi've only listed afew fields)
report from server1
-------------------
Time calloffered callsAnswered callsabandon avrageTalktime
00:00 13 7 6 12.30
00:15 26 26 0 10.76
00:30 5 4 1 0.55

report from server2
-------------------
Time calloffered callsAnswered callsabandon avrageTalktime
00:00 24 4 20 0.32
00:15 12 12 0 12.00
00:30 9 4 5 1.45

Summation
---------
Time calloffered callsAnswered callsabandon avrageTalktime
00:00 37 11 26 12.32
00:15 38 38 0 0.21
00:30 14 8 6 0.67
----------------------------------------------------------
total: 89 57 32 6.32

Is there any way to merge the 2 reports together?

thnaks in advance!

 

[kskid]

Insert the 2nd report as a subreport and use shared variables for your summation.

-lw

 

[sugu]

sorry, i forgot to mention that the reports are generated from 2 different pcs.

is it possible to merge the 2 reports from different servers in the 1st place?


thanks

 

[sugu]

The initial rpt template uses a subreport. So, will it work if the 2 templates(from the 2 servers) r imported to a main report?

thanks!

rgds,
su