JB,

I can't do it this way.  The data resides on a SQL Server DB, which
will be transparent to our client.  I won't be around in a month, so if
the client wants a report with different sets of data, then they will
have to do it themselves.  I'm using a .sql file with a SELECT query
that is read in, checked for validity, saved as a stored procedure, and
then executed in a CRecordset derived class.  This recordset is then
scrolled through, and each row's columns are saved in whatever format
the XSD file tells it to be in.

Then the XSL/XSLT formatting file is executed using DOM, and the output
file is brought up in a browser.

I figured out how to do what I wanted.

Actually, I wonder if I could copy some of hte Access XSD files for
formatting.  Good call, thank you.

-Benry


SQLDude wrote:
> The last step for the SQL is to end your SQL statement
> with FOR XML, AUTO ELEMENTS and the XML table
> is filled with the result set of the query into a structured
> XML data island already.   I can send you samples of
> one entire round trip if you send me an email to
> jfbevilaqua@g...   This is truly the way to do it.
> 
> JB