This Field is missing from returned result set from data source

Posted on 2013-06-27
Last Modified: 2013-06-27
SSRS 2008

Added another field to my stored procedure query.
Refreshed my report data set
See field in data set
Went to data set query designer and ran query and see field with data
Execute report and data does not appear in the report.

I see these 2 warning messages which explains why I do not see the data on the report.
But do not know how to correct.
Never have seen this before. It was such a simple change.

Have spent hours on this.

Question by:thayduck
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
  • 5
  • 4
LVL 65

Expert Comment

by:Jim Horn
ID: 39281616
<Potentially stupid questions>
(1)  Did you execute the change in your SP so that it is returned?
(2)  Is the SSRS textbox for this new column Hidden?
(3)  Is the SSRS textbox for this new column separate, or part of the matrix/tablix that has the Data Set that uses the SP?
(4)  Is the SSRS textbox for this new column containing a typo so that is is not referring to the new column?
(5)  Is the Color same as the BackgroundColor

Author Comment

ID: 39281643
I did try putting a different field from my query into that textbox and that field (with data) did appear in the textbox. When I put the field in question back, the textbox is blank.

It is all part of one tablix. Very simple report. Very simple change. I went to the internet and users have complained about this same issue.
LVL 65

Expert Comment

by:Jim Horn
ID: 39281660
>'The field is missing from the returned set from the data source'.
That implies the SP has a column named Konzsy, but the data set does not.
Perhaps a good idea would be to complete delete and re-create the data set.
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.


Author Comment

ID: 39281676
I have done that many times already.

I can see the field in the data set.

I see it (with data) in the query but do not see the data in the report.

Author Comment

ID: 39281773
I see what the problem is
They recently switched us over to sql 2008 r2.
My sql database for this reporting system was on server sqluat009.
It is now on server sqluat027.
I changed my data source in my report to sqluat027
When i ran data set query I see my field with data but do not see on report.
I made the same change to the report stored procedure query on the old server sqluat009.
Now when I execute the report, i do not get any errors and the report shows my data.

So what it looks like, when I execute the data set as a query, it runs over sqluat027, but when I execute report, it is running stored procedure from old server sqluat009.

Do you know how I would make sure everything is run over the correct server which is sqluat027 ?
LVL 65

Accepted Solution

Jim Horn earned 500 total points
ID: 39281800

>So what it looks like, when I execute the data set as a query, it runs over sqluat027, but when I execute report, it is running stored procedure from old server sqluat009.
>Do you know how I would make sure everything is run over the correct server which is sqluat027 ?

How many Data Sources are we talking here?  
   If there's only one, then as long as that is set to whatever is the 'correct', all Data Sets should run off of it.
   If there's more than one, then you're going to have top open each Data Set, and make sure it's pointing to the correct source.

Also, if users are running these reports off of an app server, you may have to do a Right-Click:Manage on each .rdl, and point to the correct source, and hit Apply.

Author Comment

ID: 39281894
I deleted my shared data source and recreated a pointing to correct server, now everything is working correctly.

Author Closing Comment

ID: 39281922
Thanks for you help. It got me pointed in the right direction.
LVL 65

Expert Comment

by:Jim Horn
ID: 39281938
Thanks for the grade.  Good luck with your project.  -Jim

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Suggested Solutions

Title # Comments Views Activity
SSRS parameters, tablix filter question 17 54
SSRS UK Map with Postcodes 2 165
SSRS Dynamic Date Parameter 25 576
Chrome SSRS print Functionality 1 76
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
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…

762 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