Stored proc output to Report

• SkyBVI

  SSCoach

  Points: 15115

  More actions

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  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)

• SkyBVI

  SSCoach

  Points: 15115

  More actions

  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