I have been trying to create an SSRS report using a stored procedure. The stored procedure has used SQL and XML schema to retrieve the data. My question is, Is it possible to create the report having both SQL and XML in the stored procedure? Or do we need to change the XML functionality to a relational database table making the whole thing a SQL Stored Proc. Please help me out with this. Let me know if you need to see the code.
Thanks in Advance