I'm doing a project where my report developer team is developing reports in Crystal reports XI.
This report use oledb provider to connect to sql server 2000.
I have tables name like
so same table in different owner/schema.
Crystal report is using "pqrowner.xyztable" and it runs fine in crystal report.
I'm have embedded this report in asp.net 3.5 and using 18.104.22.168 runtime. When this report is run in asp.net application using
CrystalDecisions.CrystalReports.Engine.ReportDocument() , it's using table in different schema i.e. "abcowner.xyztable".
I have to manually change the location of the table to point to correct owner. I can't fix like this becuase the application wouldn't know which owner/schema to pick.
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
crTableLogonInfo = crTable.LogOnInfo;
crTableLogonInfo.ConnectionInfo = crConnectionInfo;
string strLocation = crConnectionInfo.DatabaseName + "SCHEMA/OWNER." + crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1);
crTable.Location = strLocation;
Any suggestion ?
Thanks in advance.