Post reply

Stored proc output to Report

  • April 28, 2011 at 11:49 am

    #237426

    Hi,

    I am a novice to SSRS.

    I have a job whcih has 2 steps:-

    1. SSIS package (data importation from remote server)

    2. Stored proc output.

    I want to see the output of the stored procedure on the Report Server.

    How to proceed?

    Any help is appreciated.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • April 28, 2011 at 1:03 pm

    #1317487

    This is really to broad a question for a good answer. In a nutshell:

    Open BIDS and start an SSRS Project

    Add a shared datasource to the server with the stored procedure on it.

    Add a new report, or run the wizard adding your SP as the dataset

    Format your report

    Deploy report to Report Server ( You must know the folder structure, and the URL of the server)

  • April 28, 2011 at 1:11 pm

    #1317495

    thanks a lot

    Can you provide some links for all that stuff, so

    that i can read and understand the basics..

    Thanks

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply