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.