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