2 database 1 report lam sao giai quyet ?

[thangdung]

Chao cac ban !

minh gap mot van de sau xin duoc chi giao.

minh co 2 database SQL Server 2000 co cau truc hoan toan giong nhau
(chi khac database name). crystal report su dung ODBC de ket noi du lieu, trong VB su dung Crystal control ocx de goi report, chuong trinh cua toi co the ket noi den 1 trong 2 database nhung van sai chung 1 report
duoi day la doan code goi report :

---
CrystalReport1.ReportFileName = App.Path &
"\reports\tonkho.rpt"
CrystalReport1.Connect = "DSN=QLKHO;
UID=sa;PWD=dsc;DSQ=SYSDB"
----

khi ket noi qua dabase khac minh tao 1 DSN den dabase do va chinh sua lai
chuoi connect tren. chuong trinh van chay tot nhung khong the hien thi bao cao len duoc.
(noi nom na la minh su dung 1 bao cao tonkho.rpt cho 2 dabase la khong duoc)

ban nao co cach giai quyet giup minh voi !

cam on rat nhieu,

[H2T]

thư xài đoạn code nay xem sao nhe :
giả dụ bạn dùng view : vwTonKho để design báo cáo
Dim mDataFile$
Dim mNewDataFile$
.......
CrystalReport1.Connect = "DSN=QLKHO;UID=sa;PWD=dsc;DSQ=SYSDB"
mDataFile = CrystalReport1.RetrieveDataFiles
mDataFile = CrystalReport1.DataFiles(0)
mNewDataFile=new_db_name & ".dbo.vwTonkho" ' chú ý dòng này
CrystalReport1.DataFiles(0) = sNewDataFile ' chú ý dòng này
......

[thangdung]

Cam on H2T, de minh thu doan code cua ban roi se thong bao sau

[thangdung]

lam sao de goi duoc thu tuc sau

create procedure Dailyreport
@productid varchar(1000),
as
select * from vdailyreport where productid in (@productid)

-----------
minh muon dua vao thu tuc nay mot day cac ma san pham
chang han nhu :
exec dailyreport 'V015',V020','V023','V024' (khong chay duoc)
neu dua vao 1 tham so thi duoc (exec dailyreport 'v015')

rat mong duoc chi giao !.

cam on.

[thangdung]

xin chao H2T
minh da thu doan code cua ban chuong trinh chay rat tot, cam on rat nhieu !