XML based reports

[Al Kaufman]

I have an Access 2003 application using SQL Server as a backend. A separate
web application allows access to and maintenance of the SQL Server data.
For reasons (related to data variablity and quantity) that I won't explain
some of the information captured via the web site is save as XML in a field
in a table. For example, if the web site allows the user to enter name,
address, city, state and zip; the data are not saved in separate fields in a
table but all the data are saved as XML in a single varchar field.

Now we need to report on that data. What's the best way?

Thanks,

Al

 

[Albert D. Kallal]

I guess I would just take that one field, and write it out to disk as a
standard xml file..and then report on it....

does the text have line feeds? You likely can send out the whole text, like:

dim f as integer
dim strMyTextBuf as string

strMyTextBuf = some big text field..

f = FreeFile()

open "c:\data\text.xml" for output as #f
print #,strMyTextBuf
close f

You now need to link to that xml file..and then report on it. It is
certainly do able. We are not talking to much code here. If you do this once
manually, and then link a table to the text xml file..then you can ALWAYS
use the same output file name (saves you having to write re-link code).

 

[Al Kaufman]

Thanks, Albert.

So I can create an Access 2003 report directly from an XML file without
having to import it into Access?

Al