Any way to UNION 2 tables from different unlinked servers?

[ITCPhil]

I don't know if this is the place to post this, I am hoping that Crystal 10 has a way to do this but not really expecting anything.

Senior management has request a KPI dahsboard report and I have to make it from Crystal as I've no other tool which makes these kinds of dashboard. I can easily get my ticketing system data, but for telephony data it gets difficuly, here is why.

Due to cost/technology issues, when our department went from multiple regional help desk to a national help desk, we divided into 2 sites with their own symposium server. The servers contain identical views/tables, but the data contained on each site is not mirrored on the other site. Everything is independant, when a server crashes, one site is affected and the data lost only for that site, the other isn't even aware of a problem.

So would anyone know if there is a way to either join or make a union of these to be able to show my KPI as 1 large entity instead of splitting up both locations?

I am thinking I will need to make my reports , export to Access and join it all there right? Or is there something else I can do?

 

[MisterMo]

You didn't say which database is used and if these servers are networked.


-Mo

 

[ITCPhil]

Oops, I had it but removed it, the databases are Sybase 12.

And the servers are not networked together at the data level, the PBX/Meridian server is what divides the calls, it only goes 1 here, 1 there, it does not look at availability or anything like that.

I did find a report where this was done with shared variables to pass the data, but for charts and percentages, it would not be a viable answer as even though 1 site might have a 90% service level and the other a 95% service level, the average is not 92.5% as one site might have taken 20% more calls than the other and have 30% more staff on the phones. It would get difficult doing this with share variables.

Thanks,
Phil