SQL Reporting Services - Cryptic Warnings

Question

I'm using reporting services in local processing mode.

I'm setting the report data to a Dataset pulled from a sql database.

When I come to render the report I get two warnings:

1. The data set ‘PPA_Dev’ contains a definition for the Field ‘EMail’. This field is missing from the returned result set from the data source.

2. The data set ‘PPA_Dev’ contains a definition for the Field ‘EMail’. The data extension returned an error during reading the field. There is no data for the field at position 9.

What I'm seeing in the generated report is the email column empty.

Why might this be happening?

UPDATE

The sql that was generating the dataset was returning the correct information.

In the end I fiddled around with the rdlc file in notepad, broke the whole report, reverted the code and it now works correctly. No idea why it was broken, no idea why it's fixed, it's all very frustrating.

Answer 1

It sounds like the dataset definition includes a field called "Email" which is not being returned from your source query, but it's difficult to be sure without more information.

Could you amend the question to include the SQL used to generate the dataset?