Post reply

How to create a report based on stored procedure

  • May 28, 2010 at 11:49 am

    #387042

    I am trying to create a report based on stored procedure, but in Report Datasets/DataSet1 it does not list the fields, so I don't have anything to drag into layout area. If I try to drag whole DataSet1, nothing happens. Please advice.

    Thanks

  • May 28, 2010 at 11:55 am

    #1174082

    How do you have your stored procedure defined?

    Are you explicitly naming the columns in the proc to be returned or simply doing a select *?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 28, 2010 at 1:05 pm

    #1174100

    I already found the problem. My DataSet1 did not show the + sign on its left side. I refreshed Report Datasets and it appeared there, showing all columns. Thanks.

  • May 28, 2010 at 2:15 pm

    #1174127

    Thanks for posting back with the answer.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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