Post reply

Stored procedure not working in ssrs dataset

  • August 29, 2012 at 2:06 pm

    #266041

    I have a report and I am using a stored procedure for the dataset which is working in ssms and has 3 input paramets but it produces no output in ssrs after putting values for the parameters.

    I could not find any reason for this issue.

    Any suggestions??

    Thanks in advance.

    Blyzzard

  • September 1, 2012 at 10:30 pm

    #1532715

    I was trying to troubleshoot and figured that when I create same stored procedure on a test server and then use it for the report dataset, it executes fine but I am not able to execute it when I connect the report to the live server.Could it be a permission issue??

    My report is using windows authentication and not SQl Server authentication.

    Thanks,

    Blyzzard

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

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