April 21, 2008 at 2:52 am
I'm using SQL Server Reporting Services 2005 and I'm trying to create a report. Again and again I'm getting this error:
[rsDuplicateScopeName] More than one data set, data region, or grouping in the report has the name ‘DimTimeEnglishMonthName’. Data set, data region, and grouping names must be unique within a report.
I have no idea what the reason for that is :crying:
I have one table on my report and one datasource. I define DimTimeEnglishMonthName as a filter (parameter). My report has two groupings with different names.
April 22, 2008 at 4:52 am
I think you copied over the layout of the table from another existing table in the same report.
Try re-building the table from scratch by dragging in a new table and the corresponding fields from the dataset.
Hopefully it should work then!
April 22, 2008 at 3:42 pm
Open your report, click Data tab, and select Dataset dropdown and view whether there is a duplicate dataset, if does exist, just delete it.
I think when you are report from analysis service, and you change any thing in your report parameter, it automatic recreate parameter dataset, it should be a bug.
April 23, 2008 at 1:51 am
Thanks a lot for your hints.
Kevin you are right.:) I had in the dataset dropdown twice parameter with the same name. And this was the conflict! Thank you again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply