Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Stored Proc output to Report

Author  Topic 

skybvi
Posting Yak Master

193 Posts

Posted - 2011-04-28 : 13:53:12
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
DBA
West Indies

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-28 : 14:09:54
Create a report that calls that stored procedure.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

skybvi
Posting Yak Master

193 Posts

Posted - 2011-04-28 : 14:55:15
Thanks for replying...
As I am totally new to SSRS,
can you plz guide me or show a link where from I can
read and understand the basics ,how to do it..


Regards,
Sushant
DBA
West Indies
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-28 : 15:21:33
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en
http://www.microsoft.com/sqlserver/en/us/default.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -