Error: [rsMissingDataSetName] The data set name is missing in the data region ?DataSetName

This error occured under the following circumstances:
1. Had an existing report that was working with 1 DataSet.
2. Added 1 new Dataset with the same data source as the existing Dataset.
Query was very simple: Select * from TableA.
3. Tested Query. Returned correct results.
4. Selected Preview and get the following message:
[rsMissingDataSetName] The data set name is missing in the data region ?DataSetName?
THis happens no matter what dataset is added.
I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
Any idea how to fix it?
Thanks
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou need to set the dataset name in the properties, of the table or chart
you are using. Just select the whole table or chart, right click, click
properties and fill in the dataset.
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||You have some region or table or something on the report that pointed to a
dataset that no longer exists. Or, and reading closer this might be what is
happening, you have a data region without a dataset. Go to layout and you
can click on your different regions and then in the properties set it to you
existing dataset.
One other thing that has happened to me before, I ended up with some data
region defined in the xml source (the report definition is XML) that was not
visible from the development environment. Save your report somewhere before
doing this (click on report in the report list, ctl-C, ctrl-V). Now you can
view code of the report and search for DataSetName and see where you find
it. The XML is pretty seld explanatory in most cases.
Lastly, just create a new report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kevin" <johnnyparsons@.hotmail.com> wrote in message
news:81b00b63-35e3-473a-bb87-f1d6e178dfbd@.developmentnow.com...
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region
> 'DataSetName'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only
> changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||Thanks all.The table in the Report must have automatically defaulted to
the 1 dataset I had. When I added the second one it didn't know which
one to use.
I set it to the correct one and all is working.
Thanks much!
Kevin|||Hey Kevin,
In reporting services layout, Select your table (or what ever object you're
building the report with), right click it, go to properties and select the
other data set
from the drop down box.
This should work .
Good Luck..
Scott
"Kevin" wrote:
> This error occured under the following circumstances:
> 1. Had an existing report that was working with 1 DataSet.
> 2. Added 1 new Dataset with the same data source as the existing Dataset.
> Query was very simple: Select * from TableA.
> 3. Tested Query. Returned correct results.
> 4. Selected Preview and get the following message:
> [rsMissingDataSetName] The data set name is missing in the data region â'DataSetNameâ'
> THis happens no matter what dataset is added.
> I tried copying the first dataset in XML format and pasting ir in and only changing the name and it still reported this error.
> Any idea how to fix it?
> Thanks
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>