Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot change table location for subreport in Crystal
Message
 
To
10/04/2003 12:17:33
Don Gorr
Data-Tel Info Solutions
Mesa, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00776178
Message ID:
00776598
Views:
13
Don,

Perhaps you need to make sure you are establishing the correct location of the ODBC source itself. For example, in our application we allow the user to dictate at runtime the name of the ODBC DSN to use for the application. Then in our reporting routing, we loop through all the subreports in a report and set the ODBC server as follows:
oSubreport = oCrystalReport.OpenSubreport(aSubreports[i])
      
FOR EACH oTable IN oSubreport.Database.Tables
      
   oTable.SetLogonInfo(cODBCDataSource)
         
ENDFOR
Hope that helps.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform