I need to create a report containing data from a MS SQL database AND data from within an XML file that is stored in the same database (so it is actually a databas within a database). Is this possible using Jasper 4.7.1 and how can I do this? I have some experience writing SQL queries, but this is really difficult. My thoughts right now are to export the XML file to a directory, although I do not know how to do that using SQL. From the main report (showing data from the MS SQL database) I need to create a subreport that can handle the XML file.