The query contains more than one unnamed or duplicate field name

In SSRS when trying to refresh my dataset I get the error message "The query contains more than one unnamed or duplicate field name".  If I run the stored procedure it executes fine.  However the issue just exists in SSRS.  I have listed my column names and I do not see the duplicate field name.  Is there a query or steps I can take to identify what field name is causing the problem?  Please advise.
Gary HarperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, only validating field by field will help you to solve the issue.
for example, remove 1 field after the other until the problem goes away.
or start with 1 field, and add back 1 field after the other until you get the issue.
0
planoczCommented:
It sounds like when you imported in the dataset you might have added a field that shows a diiferent field name but is seeing two field type that are the same in name (but has different ID names)
Edit the report in BIDS and  on the leftside expand the dataset and compare each field listed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>"The query contains more than one unnamed or duplicate field name"
SSRS requires that every column name be unique within a data set.

>If I run the stored procedure it executes fine.
Maybe, but do you have more than one column without a name, or two columns with the same name?  This will often happen if you have any SELECT *'s, or Customers.CustomerID and Orders.CustomerID, both can be named CustomerID.

>I have listed my column names and I do not see the duplicate field name.
Just for kicks and giggles, post your query into this question, using a code block.
0
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I'm guessing that our awesome mind-reading skills used to interpret 'the query' resulted in a solution here in the first couple of comments.  

In case it didn't thoughm just for kicks and giggles, post your query into this question, using a code block.
0
Gary HarperAuthor Commented:
The column names had greater than and less than symbols in the name.  SSRS interpreted this as underscores.  So the field names appeared to be the same.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.