December 22, 2011 at 12:15 pm
I created a new Data Source and I specified a Stored Procedure a the Source, however the change is not taking affect.
I added a CASE Statement to the SP to change the Values of the Column from what it was in the COmmand Text Data Source so I no that the Report is not using the SP.
In the past from the data table I would click on the Exclamation to Execute and click on the refresh fields button and it worked.
The SP is going pulling Data across several servers so it is not the fastest SP.
Could it be that I'm not giving it enough time to refresh the fields?:unsure:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 23, 2011 at 9:36 am
No ideas?:crying:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply