Showing posts with label existing. Show all posts
Showing posts with label existing. Show all posts

Wednesday, March 28, 2012

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Report designer - how you refer to an existing field in calculation

Hi,

This seems simple but can't find. Say in my report I have 3 fields(A,B and C).

In field C I want to give a calcultion based on fields A and B. Say field C value = A+B

How do you do this? In expressions I couldn't see existing report fields, it only shows dataset columns.

Sonny

Hi Sonny,

You have several options to do something like this.

You can create a calculated field in your dataset:

In your dataset window, right click on the dataset and select Add Type in the name (FieldC) Select Calculated Field and type in =Fields!FieldA.Value + Fields!FieldB.Value In the textbox where you want FieldC to be, type in =Fields!FieldC.Value|||

Hi Jessica,

Thanks for the answer.

Sonny

Wednesday, March 7, 2012

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.

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.

Tuesday, February 21, 2012

Replication: remove merge subscription without existing publisher?

Hi all,
I'm a rather newbie, not only to this forum but also to sql server having a question to the following issue:
Is it possible to drop/remove/delete the "orphan" of a merge subscription on one instance of sql server without having the (former) distributor/publisher (on other instance) available?
The background is: I had a small replication infrastructure with two instances (on two machines), one the publisher and distributor, the other the subscriber. Now it happened that the publisher/distributor machine was completely set up new without having the replication dropped in advance, what remained on the subscriber is now a database with all the merge/replication tables and the guid columns in the user tables.
Moreover this, an entry remained in the subscription saying that a subscription with the former publisher exists...

Can I remove these "orphans" without having to setup the instance again?

Thank you,
AndyDid you recreate the Publisher again?|||Originally posted by smasanam
Did you recreate the Publisher again?

No, I didn't recreate the publisher, but I plan to do so, however, with slightly different properties (e.g. publisher db name has changed)...|||Originally posted by AndreasJaehn
No, I didn't recreate the publisher, but I plan to do so, however, with slightly different properties (e.g. publisher db name has changed)...
Sorry to ask again. Can you please give more details about your question.

Looks like you want to drop the subscription. If that is so you can drop the subscription or subscriber database.

Once you dropped the subscription and remove the subscription databases you can go head and change the schema of the database at the subscriber|||Originally posted by smasanam
Once you dropped the subscription and remove the subscription databases you can go head and change the schema of the database at the subscriber

The thing is that I cannot drop the subscription as this implies having a valid publisher, but I don't have the publisher anymore. The system Stored Procedure requires the publishing/distributing instance alive, even if I set the ignore_distributor flag...

I found something in the archive which comes quite close to my problem: http://dbforums.com/arch/69/2002/4/348973

I'll try it that way (see Ramakrishna Koni's comment)...

Thank you.