Report Builder not showing fields

CREATE PROCEDURE spGetData
AS
BEGIN
      -- DML Statement
      -- DML Statement 
      -- DML Statement
      -- DML Statement
      -- DML Statement
      -- DML Statement
      SELECT Field1,Field2 FROM TableName      
END

If we use above stored procedure as Dataset in Report Builder wizard select fields

will not reflect during design time.So to avoid this issue we need create Data Source
and Data Set manually instead of wizard.

 

 

That’s It.
Enjoy Learning.