How to Dynamically set sub-report data source from Parent report?

Dear Forum,

I am writing some crystal reports against the RoutSmart (For Arc GIS) Report.mdb (Access db). Now in the db, which is dynamically generated, there are a number of tables holding summary and detailed data. The problem I have is that the detailed data for each route is held in a table that has the route id hardcoded into the the table name (eg. myTableName_RouteID)

What I want to do is create a report that lists all routes from the summary table and then uses the list to look up detailed data from the respective detail tables. (eg myDetailedData_Route01, myDetailedData_Route02 .....)

The restrictions I am fighting are:
1) I cannot write any code in the db as it is deleted/created as required by the routesmart app.
2) I have no way to know how many routes or what they will be called/ID'd
3) I have no control over the RouteSmart report interface that a user uses to open the reports.
4) The RouteSmart interface will re-point the report to the correct db for the user (again outside my control and rules out using a second db with code in it)
5) I believe the only way forward is to change the subreport data source from the parent report.

Is it possible?

Kind regards

Jon Martin

Don't think you can change the db connection of a sub-report dynamically.
What you can do is have multiple sub-reports placed in various sections of a main report.
Then use suppression formula to determine which sub-report runs