SSRS Field Added in Stored Procedure not showing in Report Designer

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?
Karl_markAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
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)
0
ValentinoVBI ConsultantCommented:
What happens if you create a new report and use the SP in there?  Does that work fine?
0
Karl_markAuthor 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!
0
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<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.
0
ValentinoVBI ConsultantCommented:
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?
0
Karl_markAuthor 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!
0
ValentinoVBI ConsultantCommented:
In Solution Explorer?  Ow, are you using a Shared Dataset?  Well yes, that would indeed be needed then...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Karl_markAuthor Commented:
It would seem so! Thanks for your assistance anyway; sometimes just having a conversation prompts one to find the solution!
0
ValentinoVBI ConsultantCommented:
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 :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.