Report based on XML recordsource

[Al Kaufman]

Can I generate a report based on an XML recordsource, i.e., without
importing the data?

If so, how?

Thanks,

Al

 

[SA]

Al:

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.

 

[david epsom dot com dot au]

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.

(david)