Crystal Reports DataBase Fields
Hi, I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO. Thanks.You cannot set the database connection string from the SBO connection information because the password is encrypted.
I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO.
But if can grab the password from somewhere else you can do it like this:
private void SetConnectionInfo(CrystalDecisions.Shared.ConnectionInfo crConnectionInfo, ReportClass report)
report.SetDatabaseLogon(conn.UserId, conn.Password, conn.Server, conn.Database);
crConnectionInfo.ServerName = conn.Server;
crConnectionInfo.DatabaseName = conn.Database;
crConnectionInfo.UserID = conn.UserId;
crConnectionInfo.Password = conn.Password;
foreach(Table table in report.Database.Tables)
crTableLogOnInfo = table.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
string s = table.Location;
s = crConnectionInfo.DatabaseName + "." /*dbo." */ + table.Location.Substring(table.Location.LastIndexOf(".") + 1) ;
table.Location = crConnectionInfo.DatabaseName + "." /*dbo."*/ + table.Location.Substring(table.Location.LastIndexOf(".") + 1) ;
Hope this helps,
- 1 Using LCD HDTV as a display Buyer Beware!
- 2 Unit of measure issue
- 3 SAP CRM integration with SAP R/3 using Xi
- 4 TS1277 I am trying to purchase extra lives for a game app and a message pops up saying 'your purchase cannot be completed' go to a website for support???
- 5 Microsoft Office Product Key
- 6 Trading Partner ID
- 7 Variant description in ME6G
- 8 Mac OSX mavericks - can't change the default app for InDesign
- 9 Service Notification and service order in ISU
- 10 Mapping Stuck Threads to Proxy Services
- Creative Cloud spinning blue wheel, cannot download CC program or update CS6 programs
- 10.4.8 and RealPlayer
- After I updated user for i phone 4 s iCloud password is no way I can not phone and e-mail address has been blocked. I did not bring the solution to Turkey APPLE chief BILKOM is forgotten the password and e-mail address in the e-mail address asking for hel
- Having issues with iTunes.
- How do I start remote programs?
- Why do old purchases always transfer when I sync my phone?
- Can spyware be downloaded on my computer in join.me?
- How to filter PO outbound messages
- Mail for Excahange not loading