Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSRS Field Added in Stored Procedure not showing in Report Designer

Posted on 2014-02-26
9
4,157 Views
Last Modified: 2014-03-04
I create a report based on a stored procedure in SSRS. After creating the report, we needed to add a new field, so I altered the stored procedure and checked it was working fine which it is.
I then went into SSRS and refreshed the fields in the dataset. It shows the new field in the dataset. However, when I try to add the field in Report Designer, it does not show up. I tried deleting the dataset and then adding a new one, but it still is not available in Report Designer. If I execute the procedure in the dataset it does show all the results including the new field.
What do I need to do to get the field to be available in Report Desiger?
0
Comment
Question by:Karl_mark
  • 5
  • 3
9 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39888477
What do you mean with Report Designer?  Report Builder or Visual Studio/Business Intelligence Development Studio?

Edit: okay, probably BIDS, sorry for this silly question... (I always use BIDS as tool name)
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39888484
What happens if you create a new report and use the SP in there?  Does that work fine?
0
 

Author Comment

by:Karl_mark
ID: 39888532
It works fine if I create a new report; it's updating existing ones where there is a problem.

PS, yes, it's BIDS. I should have specified!
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 65

Expert Comment

by:Jim Horn
ID: 39888648
<wild guesses>
Make sure your tablix/whatever is pointing to the correct dataset.
Make sure the column name does not have any spaces or punctuation marks other than underscore ( _ ), which would force you to surround it with square brackets [ ] when referring to it, and perhaps sort it in the bottom of the combo box that selects columns.

Once the dataset recognizes the new column it *should* be automatically available for use.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39888667
but it still is not available in Report Designer.

Do you not see it when you click the + icon next to the dataset name in the Report Data window, is that an accurate description of your issue?
0
 

Author Comment

by:Karl_mark
ID: 39888687
Actually, just solved it. I had to refresh the fields in the dataset under Solution Explorer as well as in Report Data. One would think that doing it in one would also do it in the other, but this is not the case it would seem!
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39888761
In Solution Explorer?  Ow, are you using a Shared Dataset?  Well yes, that would indeed be needed then...
0
 

Author Comment

by:Karl_mark
ID: 39888796
It would seem so! Thanks for your assistance anyway; sometimes just having a conversation prompts one to find the solution!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39888809
Well, sure...  Next time though don't forget to mention critical details like that, it will help both us and you to come to a working solution a bit faster :)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 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