asked on

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.

Howard Cantrell

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.

sureshbabukrish

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

EYoung

ASKER

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.

ASKER CERTIFIED SOLUTION

Howard Cantrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EYoung

ASKER

Yes, that did it. Thank you.