How do I create an SSRS with stored procedure

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
Who is Participating?
ranjith0827Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.