it is possible.
as far as i know, you can do it from SQL (not in CR).
you should have same Function / Stored Procedure (SP) / Table in each Databases (e.g.: fn_abc() ).
this function is to collect data from the current DB.
then make a global function in master DB (e.g.: fn_all()) to call those SP/Func/Table from each DB using UNION all.
and create another simple SP in each DB (e.g.: mysp_xxx)to call the global function.
then use this simple SP for Crystal Report (CR) to format the report.
here is an example:
in DB A: fn_abc() --> to collect records from current db
in DB B: fn_abc()
in DB C: fn_abc()
in DB master: --> to collect records from all db
fn_all()
select * from a.dbo.fn_abc()
union all
select * from b.dbo.fn_abc()
union all
select * from c.dbo.fn_abc()
end
to collect all data from db where we login:
in DB A:
alter Procedure MYSP_xxx
select * from
master.fn_all()
in DB B:
alter Procedure MYSP_xxx
select * from
master.fn_all()
in DB C:
alter Procedure MYSP_xxx
select * from
master.fn_all()
in this case use MYSP_xxx in your CR.
hope it help.
and glad if it is
Edited by Emir_W - 15 Jun 2010 at 7:20pm
IP Logged
