Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yonabout
Posting Yak Master
112 Posts |
 Posted - 2008-10-30 : 11:05:32
|
Hi,Is it possible to get Crystal reports to access an XML document thats stored as varchar in a SQL table?We've got a database that stores calculation results as an xml string against a unique PersonID.I also need to pick up data from a normal data table in the same database.I've used crystal to access SQL databases, and I've also used it to access standalone xml documents, but I need to know if you can use it to access xml stored in an sql table.Is this possible?If not, my next option is to build an app to extract the xml from the data tables into an interim SQL database, then use crystal to report on this.Does that sound more realistic?By the way, I'm still on SQL 2000, but if you want to try any of your fancy SQL 2005/8 solutions on me, then I can use them as further justification for an upgrade  .Cheers,Yonabout |
|
|
|
|
|
Crystal and accessing XML stored in a database