August 15, 2009 at 9:40 pm
I'm a n00b at RS. I'm still working on my first report and anytime I go back and change anything in my SQL script, my dataset parameters keep disappearing. If you look at the attached screen shots, parameters.jpg show my parameters before I make changes to SQL. error.jpg shows the error I get when I hit the save button after saving my changes to my SQL script. parameters2.jpg shows what my parameters window looks like when I go back in to look at the dataset parameters.
How do I get these parameters to stick so I don't have to keep entering them in? It's honestly getting annoying having to re-key them in every time.
I'm using 2005 SSRS with an OLE DB connection to a 2000 database.
August 17, 2009 at 2:37 pm
I too have had that problem, and all I've been able to determine is that RS gets stupid from time to time.
If you are certain your parameters are not going to change, you could put your query into a stored procedure. That way you can make changes to the proc in SSMS and just re-run it in RS and refresh the dataset.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply