Error: [rsMissingDataSetName] The data set name is missing in the data region 'DataSetName'
in [Reports]
|
Prev: RS2005: again... anyone know how to use the descriptionlocid, valu
Next: RS 2005 ReportExecutionService ToggleItem method problem - resolved ! =)
From: Ben Watts on 25 Jul 2006 14:57 You 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(a)hotmail.com> wrote in message news:81b00b63-35e3-473a-bb87-f1d6e178dfbd(a)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
From: Bruce L-C [MVP] on 25 Jul 2006 15:00 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(a)hotmail.com> wrote in message news:81b00b63-35e3-473a-bb87-f1d6e178dfbd(a)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
From: Kevin on 25 Jul 2006 15:25
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 |