March 31, 2015 at 7:24 am
I have a report that pulls its data from a stored procedure. I was asked to add a few columns to the report, and after changing the stored procedure the dataset seems to be updated correctly. The new columns are not available in the report, however. I've added columns for the new fields, but those fields aren't available in the dropdown lists. The fields are listed in the dataset properties and the query designer. Is there a way to refresh the outdated schema that the report must be storing somewhere? I'm not using temp tables, if that makes a difference.
March 31, 2015 at 2:27 pm
Can you write the query outside of the stored procedure and run the report from this dataset? You may then be able to do what you want.
March 31, 2015 at 2:46 pm
I had this kind of fun just today on SSRS 2012. I went into the dataset and re-ran the query from within SSRS. that fixed it for some reason. I guess SSRS caches the old definition or something and it gets confused sometimes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply