Solved

This Field is missing from returned result set from data source

Posted on 2013-06-27
9
1,754 Views
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.

HELP
Presentation1.ppt
0
Comment
Question by:thayduck
  • 5
  • 4
9 Comments
 
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
0
 

Author Comment

by:thayduck
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.
0
 
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.
0
DevOps Toolchain Recommendations

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

 

Author Comment

by:thayduck
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.
0
 

Author Comment

by:thayduck
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 ?
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39281800
Nice.

>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.
0
 

Author Comment

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

Author Closing Comment

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

Expert Comment

by:Jim Horn
ID: 39281938
Thanks for the grade.  Good luck with your project.  -Jim
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
CRM 2011 Lookup and populating related fields 31 263
ssrs chart? 1 22
SSRS page break on parameter values 1 47
SSRS Subscription jobs disabled, yet still running 4 34
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…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
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…

770 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