Monday, February 10, 2020
Could not update list of Fields for the query in SSRS
While Connecting to the stored procedure from the SSRS reports getting below error.
"Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct."
An item with the same key has already been added.
I have added here sample stored procedure created.
"Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct."
An item with the same key has already been added.
I have added here sample stored procedure created.
create procedure products as begin with #ProductCat as( select DPC.EnglishProductCategoryName,DPC.FrenchProductCategoryName,dpsc.EnglishProductSubcategoryName,DPSC.FrenchProductSubcategoryName from DimProductCategory DPC join DimProductSubcategory DPSC on DPC.ProductCategoryKey=DPSC.ProductCategoryKey ) select PC.EnglishProductCategoryName as Product_Category,PC.FrenchProductCategoryName as Product_Category ,PC.EnglishProductSubcategoryName as Product_SubCategory from #ProductCat PC end
Two column names are having in the output with same name.
unfortunately SSMS will not throw any error for this.
Make proper naming while naming the dataset column names.
Subscribe to:
Posts (Atom)