SSRS Field Added in Stored Procedure not showing in Report Designer

Karl_mark
Karl_mark used Ask the Experts™
on
I create a report based on a stored procedure in SSRS. After creating the report, we needed to add a new field, so I altered the stored procedure and checked it was working fine which it is.
I then went into SSRS and refreshed the fields in the dataset. It shows the new field in the dataset. However, when I try to add the field in Report Designer, it does not show up. I tried deleting the dataset and then adding a new one, but it still is not available in Report Designer. If I execute the procedure in the dataset it does show all the results including the new field.
What do I need to do to get the field to be available in Report Desiger?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
What do you mean with Report Designer?  Report Builder or Visual Studio/Business Intelligence Development Studio?

Edit: okay, probably BIDS, sorry for this silly question... (I always use BIDS as tool name)
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
What happens if you create a new report and use the SP in there?  Does that work fine?

Author

Commented:
It works fine if I create a new report; it's updating existing ones where there is a problem.

PS, yes, it's BIDS. I should have specified!
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
<wild guesses>
Make sure your tablix/whatever is pointing to the correct dataset.
Make sure the column name does not have any spaces or punctuation marks other than underscore ( _ ), which would force you to surround it with square brackets [ ] when referring to it, and perhaps sort it in the bottom of the combo box that selects columns.

Once the dataset recognizes the new column it *should* be automatically available for use.
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
but it still is not available in Report Designer.

Do you not see it when you click the + icon next to the dataset name in the Report Data window, is that an accurate description of your issue?

Author

Commented:
Actually, just solved it. I had to refresh the fields in the dataset under Solution Explorer as well as in Report Data. One would think that doing it in one would also do it in the other, but this is not the case it would seem!
BI Consultant
Most Valuable Expert 2011
Commented:
In Solution Explorer?  Ow, are you using a Shared Dataset?  Well yes, that would indeed be needed then...

Author

Commented:
It would seem so! Thanks for your assistance anyway; sometimes just having a conversation prompts one to find the solution!
ValentinoVBI Consultant
Most Valuable Expert 2011

Commented:
Well, sure...  Next time though don't forget to mention critical details like that, it will help both us and you to come to a working solution a bit faster :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial