Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

When refreshing a datasource stored proc I lose all SP parameters

Status
Not open for further replies.

eo

MIS
Apr 3, 2003
809
SQL Server 2005.

I have comprehensive stored procs serving the SSRS reports. When making a change to the SP it seems normal to click on the refesh button in SSRS > Data tab > Datas source
But every time I do this, I lose all the objects on the report (including the parameters) from the SP.

I them have to close down the project without saving to get all back to normal.

I have no idea how else to feed SP changes into the SSRS report [censored]

Any ideas?

EO
Hertfordshire, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top