Yes and no. Using ADO, you can load an XML file into a recordset. You can
then set the reports record source to that recordset. The problem however
is that through Access 2003, if you set a report to a recordset, you can't
use grouping and sorting (because the report is "late bound"). Otherwise to
simply output the raw data, yes, load the XML file using ADO into a
recordset and set the reports record source to be = to that recordset.
You can change sorting and grouping in the open event of a report.
(Set up a dummy sorting/grouping level in design view first,
grouping on something like "1").
Obviously, a bit more prone to error, but if 'late bound' is the
only problem, it should work.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
