define query parameters for my dataset in SSRS

Tom Stone 516 Reputation points
2020-08-25T20:36:07.843+00:00

Why am I being prompted to define query parameters for my dataset in SSRS when I select "Refresh Fields" when it is simply calling a stored procedure? There is an SSRS report parameter for each stored procedure parameter.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,102 questions
No comments
{count} votes

Accepted answer
  1. Tom Stone 516 Reputation points
    2020-08-26T14:45:16.313+00:00

    Joy, I did have all of the parameters assigned. The issue ended up being that the 1st parameter in the SSRS report was set to integer, and the 1st parameter in the stored procedure was set to varchar(100). Once I got all the data types aligned everything was fine.


1 additional answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2020-08-26T02:57:27.813+00:00

    Hi,
    This happens because the stored procedure was made to have parameter for it to run.

    There is an SSRS report parameter for each stored procedure parameter.

    We need to go inside the dataset property to define to 1-1 mapping relation for the SP parameter to get value from the report parameter.

    20327-01.jpg

    Could you elaborate this a bit, what you mean by this. Could you attach sceenshot to show your case?
    You could follow tutorial as in SSRS - Report for Stored Procedure with Parameters.

    Regards,
    Joy

    No comments