How do I create an SSRS with stored procedure

Posted on 2011-05-10
Last Modified: 2012-05-11
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
Question by:ranjith0827
    1 Comment

    Accepted Solution


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I'd like to talk about something that is near and dear to my heart: build systems. Without them, building software is all about compiling locally, with software versions everywhere. It can be a mess. Today we are going to discuss building a small di…
    David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now