SSRS Textbox/Expression/Category/Fields not updating with new field

I have written a report in SSRS that uses a SQL Server table.  After I wrote the report, I added a new field to the table and refreshed the report's dataset.  However, when I want to display the new field on the report by adding a new text box then clicking on Expression..., the new field does not show up in the Fields (<table name>) list.

How do I update the list of fields in the Fields list?  I have refreshed everywhere I can find in the report's DataSet.Designer, changed the select statements, added the new column to the designer, etc.  Nothing works.

Thanks for the help.
Who is Participating?
planoczConnect With a Mentor Commented:
Then open  notepad an paste acopy of the dataset.
Then cut the select statement down an then rebuild the statement back to full size.
If you are using a stored procedure, All you have to do is copy the SP name, then delete your dataset. After that add a new dataset plaste in your SP name and re-run the report.
The listing should have all the new fields in it.
there should  be a refresh icon in the dataset desinger. please click that once and try to execute it once, once you can see the dataset in the dataset designer, you should be able to see that in report designer
EYoungAuthor Commented:
planocz: I am not using a stored procedure.  Just a straight Select statement.  I have been hesitant to delete the dataset from the report as there are many fields from the dataset in the report.  Don't want to lose my hard work.  May have to anyway.

sureshbabukrish:  I have clicked the Refresh icon in the dataset designer several times.  Does not seem to pick up the new fields.
EYoungAuthor Commented:
Yes, that did it.  Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.