Share via

Why am I being prompted to define query parameters for my dataset?

Tom Stone 521 Reputation points
2020-08-25T20:01:31.147+00:00

Why am I being prompted to define query parameters for my dataset when I select "Refresh fields"? It is simply calling a stored procedure.

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,940 questions
0 comments
Accepted answer
  1. Tom Stone 521 Reputation points
    2020-08-26T14:46:59.077+00:00

    Zoe, Thanks for your input. 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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 37,671 Reputation points
    2020-08-26T02:40:22.643+00:00

    Hi,

    Please check the SQL Profiler for queries executed at back end to see if you are using parameters in the sp.

    And have you tried to type in some valid dummy values and click Ok, will the dataset refresh correctly?

    Regards,

    Zoe

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.