Thursday, March 22, 2012

changing a stored proc dataset w/parameters

Hi, I changed a report to point to another dataset. Both the old and new
data sets are stored procs with parameters. The issue I'm getting is when I
try to preview the report it is still wants the old parameters. I changed
the dataset value in the table properties and hit refreshed in the data pane.
Any suggestions.Query parameters and report parameters are two different things. When you
are creating or modifying the dataset query parameters (or in your case
stored procedure) parameters are detected and report parameters are created.
The report parameters stick around unless you delete them. In layout view,
Report Menu->Report Parameters. Click on the parameter and delete it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:799D404D-0742-4B2D-B708-49F566AFA9D9@.microsoft.com...
> Hi, I changed a report to point to another dataset. Both the old and new
> data sets are stored procs with parameters. The issue I'm getting is when
> I
> try to preview the report it is still wants the old parameters. I changed
> the dataset value in the table properties and hit refreshed in the data
> pane.
> Any suggestions.

No comments:

Post a Comment