I have created Stored Procedure in my database but I'm not able to view the same in Report Builder 3.0. Please find attached image. Is there that I'm missing something?

Looks like your missing a stored procedure. It's possible your stored procedure uses a schema other than DBO. It's also possibly a permissions issue. Can you show screenshots of: 1. the stored procedure appearing in the database explorer pane of SSMS 2. Your data source connection setup in SSRS Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

Check if you have specified credentials have permissions to the database and also you can select storedprocedure in your radiobutton and will give you the list of stored procedures in the database.Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 ) Dont forget to mark it as Answered if found useful | myspeakonbi

Hi there To me this is permission issue. So please check Right click on your stored procedure and check for permission for the user id which you are using for create datasetMake sure it at least have execute permissionCheck if the stored procedure available inside the dropdown box inside SSRS I am putting some screenshot for your help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.