Solved

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

Posted on 2010-09-03
5
891 Views
Last Modified: 2012-06-21
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
Comment
Question by:EYoung
  • 2
  • 2
5 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 33603857
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
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 33617037
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
 
LVL 7

Author Comment

by:EYoung
ID: 33622389
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
 
LVL 27

Accepted Solution

by:
planocz earned 125 total points
ID: 33622746
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
 
LVL 7

Author Closing Comment

by:EYoung
ID: 33623546
Yes, that did it.  Thank you.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question