Report Builder - Editing existing report

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

System.Web.Services.Protocols.SoapException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: More than one report item in the report has the name ‘textbox4’. Report item names must be unique within a report.
at Microsoft.ReportingServices.ReportProcessing.ReportPublishing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] definition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileReport(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, PublishingErrorContext errorContext, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(CatalogItemContext reportContext, Byte[] reportDefinition, CreateReportChunk createChunkCallback, CheckSharedDataSource checkDataSourceCallback, AppDomain compilationTempAppDomain, Boolean generateExpressionHostWithRefusedPermissions)
at Microsoft.ReportingServices.Library.CreateReportAction.ConvertToIntermediate(Byte[] definition, Boolean usePermanentSnapshot, ItemProperties properties, CatalogItemContext reportContext, DateTime currentDate, Boolean checkAccessForSharedDatasources, ReportSnapshot& intermediateSnapshot, ParameterInfoCollection& parameters, Warning[]& warnings, DataSourceInfoCollection& dataSources, PageProperties& pageProperties)
at Microsoft.ReportingServices.Library.SetReportDefinitionAction._SetReportDefinition(String report, Byte[] definition)
at Microsoft.ReportingServices.Library.ReportCreator.UpdateExistingItem(String itemPath)
at Microsoft.ReportingServices.Library.CatalogItemCreator.CreateItem()
at Microsoft.ReportingServices.Library.CreateReportAction._CreateReport(String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.Library.CreateReportAction.CreateReport(Guid batchId, String report, String parent, Boolean overwrite, Byte[] definition, Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

Nilesh Trivedi wrote:

I am working on SQL Server 2005 Developer Edition.

I have prepared a new model and based on that I prepated few reports using Report Builder. Now, I need to edit existing report to apply few more filter and new column. For that I am opening report in to Report Builder and applying new filters and adding new attribute. Everything is set. I will save this report.

Now strange thing happens....while saving this report, I am getting following error, I am not sure where this textbox4 is available on report. All attributes available on report are unique and not repeated on report anywhere.

So far I have tried lot of other options and other report, but I am not able to edit any of the existing report and getting same error. Please help if you have any hint about this.

I'm having this same problem. How can we be expected to create reports & modify if the client isn't smart enough to name textboxes uniquely. I get the error listed below in a messagebox (with a similar exception in the log files). All I do is open the report and try to save it. Can anyone from Microsoft (or anyone who has encountered and resolved) provide direction on this?

Regards,

Dan

More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report. > More than one report item in the report has the name ‘textbox2’. Report item names must be unique within a report.

|||

We have not heard of anyone else running into this. Will you use http://connect.microsoft.com to file a bug? Please attach the report (.rdl), model (.smdl), and data source view (.dsv).

|||

Thanks for the response. It doesn't occur every time, just with 1 or 2 specific reports.

I'm trying to see what I can do to reproduce it now. I was planning on submitting a bug when I can figure out what exactly causes it.