Dynamic Database Path Change in C# .NET
The Crystal Reports templates that our software uses are on the C: drive. The Crystal Reports templates selected database tables have a C: drive path. If the databases used by the report and the report templates are both on the C: drive, the reports appear correctly. If the databases are on the E: drive and the templates are on the C: drive, a Database Login dialog box with empty controls appears.
If I attempt to remedy this problem by dynamically assigning a path for the database tables:
oReportDocument.Database.Tables[0].Location = sReportDatabasePath0;
oReportDocument.Database.Tables[1].Location = sReportDatabasePath1;
oReportDocument.Database.Tables[2].Location = sReportDatabasePath2;
the report is displayed, yet data from only one of the databases appear and the data from the other two databases do not appear.
How do I dynamically assign a database table location in C# so that data from all three databases appear in the report.
Thank you in advance for any help you may provide.
Carlos
Software/Hardware used:
Software/Hardware used:
ASKED:
October 19, 2008 10:08 PM
UPDATED:
October 29, 2008 12:39 AM
RELATED QUESTIONS
- Unable to browse local intranet PHP site
- Crystal Report based on sql query with more than two tables
- Windows 7 & Crystal Reports 9 - Azalea's PostNet user function Barcode dll not recognized
- (rsErrorOpeningConnection) Could not obtain information about Windows NT
- SQL Server 2005 Legacy DTS fails when run as a job
Answer Wiki:
Sounds like a connectivity or permissions issue. Not sure what kind of servers you are using, but if you are using SQL Server, do you have remote connectivity allowed on the two servers not returning data? This can be set up through Surface Area Configuration.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
