Report based on XML recordsource

  • Thread starter Thread starter Al Kaufman
  • Start date Start date
A

Al Kaufman

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

If so, how?

Thanks,

Al
 
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.
 
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)
 
Back
Top