how to call procedures and function in ssrs

Question

how to call procedures and function in ssrs

asranantha

SSCarpal Tunnel

Points: 4246
More actions
August 11, 2011 at 11:21 pm

#243173

hi friends i small doubt .how to call procedure and functin in ssrs and ssis
plz give with example
iam tryaing to exeute like exec procename with parmerters but its not working in ssrs.how to call and how to execute.plese tell me process

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

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

visual.prabu SSC-Addicted Points: 469 More actions · Answer 1

You can achieve this by creating a new custom code and you can call this function from SSRS and you can pass parameters too.

Look into following site and i explained step by step process.

http://www.dotnetspider.com/resources/42881-SSRS-SQL-Server-Reporting-Services-Manages.aspx

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

You should just be able to select Stored Procedure as your query option, then select the appropriate stored procedure. The parameters the sproc needs will automatically be created in the report.