Web service's XML result as a Data Source for a report ?

[FMFF]

I have a webservice that returns XML which can pretty much be translated into
a two column table. This is because direct access to that SQL Server Database
is not permitted and web service is the only way to retrieve data.

My question is, how do we bind the XML returned by this web service as the
data source for my report?

 

[Larry Linson]

I have a webservice that returns XML which can pretty much be translated
into
a two column table. This is because direct access to that SQL Server
Database
is not permitted and web service is the only way to retrieve data.

My question is, how do we bind the XML returned by this web service as the
data source for my report?

Erm, in what form is the XML returned? If you place it in a two-column
table, I don't see why there should be a problem.

The Record Source of a Report has classically been either a Table or a
Query. In more recent versions, you could use an ADO Recordset -- as I am
not fond of ADO, I've used it only in conjunction with work I was doing on
someone else's ADP, and didn't use it in this manner.

Larry Linson
Microsoft Office Access MVP