Hey guys there could also be one more reason that if you would have pulled
an extra table in your report layout but for which the dataset is not defined.

So be careful on this part too.

Thanks,
Shail

"iamscott" wrote:

> 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_...g-services.htm
> >
> > Posted via DevelopmentNow.com Groups
> > http://www.developmentnow.com
> >