>I think the problem is using the TTX file, which is not required. What happens if you map directly to ADO in the designer?
>
Craig,
Could you please inform me how you create reports off ADO objects in the designer? The reason I ask this is that we only create the ADO object at runtime from a cursor just before the report is displayed, using the TTX files allows us to give the TTX files to our users / report designers to create repotrs without needing access to the database or program directly.
Previously our reports worked off tables that were copied into the users TEMP folder, the reports would then connect directly to these tables which the users could also use to create their own reports, so we do need this ability to create reports without having to have access to the Database directly
Thank You
Chris
Have a nice day :)