I have two servers A and B. Each is having two databases P,Q in A and X, Y in B.
Now i want combined reports,
1) Sales Analysis Report - From P, X, Y databases
2) Stock Report - From P, X, Y
3) Pending PO's of P.
4) Pending Po's of X and Y.
How can i get above reports. Please let me know the solution.