Solved

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

Posted on 2010-09-03
5
883 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
debugging reporting service 2008 - 2014 16 78
SSRS report failed to upload 1 600
Highlight a field based on value in another field in SSRS 4 35
Report Builder 3.0 3 25
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now