I am building a report in Crystal Reports XI and I have a few XML snippets stored in a SQL table that I need to render as subreports. I have the corresponding XSD & XSL files for validation & display but I do not know how to perform the transform inside of Crystal Reports to render the content correctly. Anyone on here know how? I checked the XML & ADO.NET XML drivers but both expect a file on the drive not XML content returned as part of a recordset from a Stored Procedure.

Thanks,
Tim

Thanks Brian. This has me completely stumped. I was pulled into this project with it 75% complete and all design work out of my hands. I have the report 85% complete with only the XML content stored in memo fields in the recordset left to add to the report.

Is there any way to add HTML content to a subreport in Crystal XI? If so I can have an ASP page create the needed html files for inclusion and put them on the filesystem somewhere.

I was thinking this might be a viable option for the XML content as well. Use a stored procedure in an ASP page to get the XML content out of the DB and using FSO to write it out to a XML file on the filesystem. The only issue I have with this is that the XML content needs to be transformed to HTML since each section can be any format the user decided to enter (i.e. plain text, Table based data, tabular data, etc.).

Any recommendations?

Tim