Dataset field list will not refresh
Using VS 2003, my dataset field list will NOT refresh when I hit the refresh button, and the field list shows NO fields! If I switch the dataset type to TEXT and enter EXEC <storedprocname>, I get fields in the list, but when I switch the type to Stored Procedure (so it can accept parameters), the field list goes blank, and WILL NOT refresh, even though I can RUN the dataset and see the data returned by the stored proc. How do I get my field list back, so that my report will compile and run correctly? Or do I have to wait for SQL Server and Reporting Services 2008 SP3??
June 27th, 2006 5:43pm
On the data tab, re-run your datasource to ensure that there are no errors. After that, right click on the "report datasets" and select refresh. If all your items appear your good, if it's missing a field, you can simply go back to the data tab and select the elipse to edit the datasource. On the fields tab, enter in 1. field name (spelled excatly and with same capitalization) 2. type - select databasefield 3. value - the exact field name (spelling and capitalization the same) this will then populate your dataset.
October 8th, 2010 10:42pm