I am using CR 10 and VB 6.
To run a report I have a function that contains the following code:
For Each crxDatabaseTable In Report.Database.Tables
.Item("Provider") = "SQLOLEDB"
.Item("Initial Catalog") = DataBaseName
.Item("Data Source") = Server
.Item("User ID") = username
.Item("Password") = password
.Item("Connect Timeout") = "5"
crxDatabaseTable.Location = crxDatabaseTable.Name
When the line crxDatabaseTable.Location = crxDatabaseTable.Name is removed, the report fails giving an error "the table '' could not be found" and when the line is inserted, reports that have tables with aliases fail giving the same error. What do I do?
Thanks in advance.