posted on Tuesday, October 18, 2005 9:07 AM by joe.sack

Reporting Services Annoyance #1

When designing a report in RS 2000, I noticed that when editing a query in the Data tab in Visual Studio that my query changes don't always "stick".  I put in the change, save it, deploy the report, and then see that my query changes didn't get saved.

Well it turns out if I make a change to an existing query, I need to press the "refresh fields" button.  This is the button that looks like the recycling symbol.  Once I press this, I see an asterisk appear by the name of my project on the window header, which means when I save the project the query change actually gets saved with it.

If anyone has a better method for making RS recognize a query change - please let me know.  I'm hoping RS 2005 doesn't have this same quirk.

Comments