• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 923
  • Last Modified:

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.
0
EYoung
Asked:
EYoung
  • 2
  • 2
1 Solution
 
planoczCommented:
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.
0
 
sureshbabukrishCommented:
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
0
 
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.
0
 
planoczCommented:
Then open  notepad an paste acopy of the dataset.
Then cut the select statement down an then rebuild the statement back to full size.
0
 
EYoungAuthor Commented:
Yes, that did it.  Thank you.
0
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now