report does not display data

Hi friends
i created a very simple report (VS 2005 standard edition). which works fine.
i added a new column to the underlying table (actually its view) . this column's data is combinations of 2 other varchar columns.
when i added this column to my report, for some reason , report does not display any data when i run the report!! actually there is data as i run that view in query analyzer.
any ideas how to resolve this issue or investigate this problem ?
Thanks for your helplooks like i need to refresh "refesh fields" .after that everything worked nicelysql

Report designer not working

Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
and Reporting Services. I downloaded and installed sample project, but no
matter what I do I can not see reports in designer. They openning as xml
files only. Any idea?
Thank you, YuriSorry, please disregard my message. I forgot to install Microsoft SQL Server
2005 Express Edition Toolkit
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Sorry, toolkit is installed, but problem is still there. Any idea? Thank you
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||Which kind of project you created? Can you see the Business Intelligence
Projects under the project types list in the Visaul Stadio?
"Yuri" <ykasan@.fojp.com> wrote in message
news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
> and Reporting Services. I downloaded and installed sample project, but no
> matter what I do I can not see reports in designer. They openning as xml
> files only. Any idea?
> Thank you, Yuri
>|||No, I see the all the usual templates and Reports For Windows Sample
Application.
This template was added after I run sample application from Microsoft
download.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||Thank you for fast response, Patrick.
Should I have a Business Int. template in my project templates?
I did install SQL 2005 toolkit for my Visual Basic Express.
"Patrick" <feng_online@.hotmail.com> wrote in message
news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
> Which kind of project you created? Can you see the Business Intelligence
> Projects under the project types list in the Visaul Stadio?
> "Yuri" <ykasan@.fojp.com> wrote in message
> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition
>> and Reporting Services. I downloaded and installed sample project, but no
>> matter what I do I can not see reports in designer. They openning as xml
>> files only. Any idea?
>> Thank you, Yuri
>|||I am sorry. I never used this way. Both I installed in my machine are VS.net
and SQL Server 2005
"Yuriy" <ykasan@.fojp.com> wrote in message
news:OI6pZwjtGHA.2448@.TK2MSFTNGP06.phx.gbl...
> Thank you for fast response, Patrick.
> Should I have a Business Int. template in my project templates?
> I did install SQL 2005 toolkit for my Visual Basic Express.
> "Patrick" <feng_online@.hotmail.com> wrote in message
> news:%236U2vLitGHA.2036@.TK2MSFTNGP05.phx.gbl...
>> Which kind of project you created? Can you see the Business Intelligence
>> Projects under the project types list in the Visaul Stadio?
>> "Yuri" <ykasan@.fojp.com> wrote in message
>> news:%23%23YP9oetGHA.1512@.TK2MSFTNGP03.phx.gbl...
>> Hello everyone. I'm trying to work with Visual Basic 2005 Express
>> Edition and Reporting Services. I downloaded and installed sample
>> project, but no matter what I do I can not see reports in designer. They
>> openning as xml files only. Any idea?
>> Thank you, Yuri
>>
>sql

report builder, which edition of 2005?

My question:
Does the end-user reporting tool (report builder) in Sql Server 2005 exist
in the Standard Version or is it only in the Enterprise Version?
I have found a couple of conflicting articles on the web.
Thanks in advance.Just Enterprise.
Not sure about development version. Previously that version was identical to
enterprise.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> My question:
> Does the end-user reporting tool (report builder) in Sql Server 2005 exist
> in the Standard Version or is it only in the Enterprise Version?
> I have found a couple of conflicting articles on the web.
> Thanks in advance.|||that is what I thought also but what about this link here. It has a
checkmark for standard...
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
More research found this information as well.
"This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
complete 180 in the way the company will license SQL Server Reporting
Services and Report Builder. Microsoft was planning to include Report Builder
in SQL Server 2005 Enterprise Edition but not Standard Edition or other less
expensive SQL Server SKUs. I thought that was going to be a big mistake for
Microsoft, and many people in the SQL Server community agreed with me. But
this week, Microsoft Senior Vice President of Server Applications Paul
Flessner announced that Reporting Services will be included in all editions
of SQL Server 2005. In addition, the Workgroup and Standard Editions of SQL
Server 2005 will include Report Builder."
taken from this artice:
http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
"Bruce L-C [MVP]" wrote:
> Just Enterprise.
> Not sure about development version. Previously that version was identical to
> enterprise.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> > My question:
> > Does the end-user reporting tool (report builder) in Sql Server 2005 exist
> > in the Standard Version or is it only in the Enterprise Version?
> >
> > I have found a couple of conflicting articles on the web.
> >
> > Thanks in advance.
>
>|||Well, how about that. The info I had was not that old but looks like prior
to TechEd they changed their mind.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
> that is what I thought also but what about this link here. It has a
> checkmark for standard...
> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
> More research found this information as well.
> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
> complete 180 in the way the company will license SQL Server Reporting
> Services and Report Builder. Microsoft was planning to include Report
> Builder
> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
> less
> expensive SQL Server SKUs. I thought that was going to be a big mistake
> for
> Microsoft, and many people in the SQL Server community agreed with me. But
> this week, Microsoft Senior Vice President of Server Applications Paul
> Flessner announced that Reporting Services will be included in all
> editions
> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
> SQL
> Server 2005 will include Report Builder."
> taken from this artice:
> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
> "Bruce L-C [MVP]" wrote:
>> Just Enterprise.
>> Not sure about development version. Previously that version was identical
>> to
>> enterprise.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
>> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
>> > My question:
>> > Does the end-user reporting tool (report builder) in Sql Server 2005
>> > exist
>> > in the Standard Version or is it only in the Enterprise Version?
>> >
>> > I have found a couple of conflicting articles on the web.
>> >
>> > Thanks in advance.
>>|||From the official press release at TechEd 2005:
http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx
"With this CTP, customers and partners will be able to test the business
intelligence components included in SQL Server 2005. To increase customers'
and partners' abilities to utilize business insight capabilities, Flessner
also announced that Microsoft will extend SQL Server 2005 Reporting Services
from Standard and Enterprise Editions to all versions of SQL Server 2005,
including Express and Workgroup Editions. In addition, SQL Server 2005
Report Builder will be available with Workgroup, Standard and Enterprise
Editions."
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uR2C6oPcFHA.2124@.TK2MSFTNGP14.phx.gbl...
> Well, how about that. The info I had was not that old but looks like prior
> to TechEd they changed their mind.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
>> that is what I thought also but what about this link here. It has a
>> checkmark for standard...
>> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
>> More research found this information as well.
>> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
>> complete 180 in the way the company will license SQL Server Reporting
>> Services and Report Builder. Microsoft was planning to include Report
>> Builder
>> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
>> less
>> expensive SQL Server SKUs. I thought that was going to be a big mistake
>> for
>> Microsoft, and many people in the SQL Server community agreed with me.
>> But
>> this week, Microsoft Senior Vice President of Server Applications Paul
>> Flessner announced that Reporting Services will be included in all
>> editions
>> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
>> SQL
>> Server 2005 will include Report Builder."
>> taken from this artice:
>> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
>> "Bruce L-C [MVP]" wrote:
>> Just Enterprise.
>> Not sure about development version. Previously that version was
>> identical to
>> enterprise.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
>> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
>> > My question:
>> > Does the end-user reporting tool (report builder) in Sql Server 2005
>> > exist
>> > in the Standard Version or is it only in the Enterprise Version?
>> >
>> > I have found a couple of conflicting articles on the web.
>> >
>> > Thanks in advance.
>>
>|||Robert,
Thank you for the clarification.
"Robert Bruckner [MSFT]" wrote:
> From the official press release at TechEd 2005:
> http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.mspx
> "With this CTP, customers and partners will be able to test the business
> intelligence components included in SQL Server 2005. To increase customers'
> and partners' abilities to utilize business insight capabilities, Flessner
> also announced that Microsoft will extend SQL Server 2005 Reporting Services
> from Standard and Enterprise Editions to all versions of SQL Server 2005,
> including Express and Workgroup Editions. In addition, SQL Server 2005
> Report Builder will be available with Workgroup, Standard and Enterprise
> Editions."
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uR2C6oPcFHA.2124@.TK2MSFTNGP14.phx.gbl...
> > Well, how about that. The info I had was not that old but looks like prior
> > to TechEd they changed their mind.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> > news:DF676812-82CA-4228-8EFA-56847C1282B7@.microsoft.com...
> >> that is what I thought also but what about this link here. It has a
> >> checkmark for standard...
> >>
> >> http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx
> >>
> >> More research found this information as well.
> >>
> >> "This week, at Microsoft TechEd in Orlando, Florida, Microsoft turned a
> >> complete 180 in the way the company will license SQL Server Reporting
> >> Services and Report Builder. Microsoft was planning to include Report
> >> Builder
> >> in SQL Server 2005 Enterprise Edition but not Standard Edition or other
> >> less
> >> expensive SQL Server SKUs. I thought that was going to be a big mistake
> >> for
> >> Microsoft, and many people in the SQL Server community agreed with me.
> >> But
> >> this week, Microsoft Senior Vice President of Server Applications Paul
> >> Flessner announced that Reporting Services will be included in all
> >> editions
> >> of SQL Server 2005. In addition, the Workgroup and Standard Editions of
> >> SQL
> >> Server 2005 will include Report Builder."
> >>
> >> taken from this artice:
> >> http://www.windowsitpro.com/SQLServer/Article/ArticleID/46694/46694.html
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> Just Enterprise.
> >>
> >> Not sure about development version. Previously that version was
> >> identical to
> >> enterprise.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "chicagoclone" <chicagoclone@.discussions.microsoft.com> wrote in message
> >> news:FAD2F770-CFA6-4F70-AD0C-662C2A99E7CD@.microsoft.com...
> >> > My question:
> >> > Does the end-user reporting tool (report builder) in Sql Server 2005
> >> > exist
> >> > in the Standard Version or is it only in the Enterprise Version?
> >> >
> >> > I have found a couple of conflicting articles on the web.
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
> >
> >
>
>sql

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.

Report builder

After I installed Developer edition I can't find Reporting services report
builder.
How can I create a new report?
ThanksIt will be a add-in in your Visual Studio .net IDE.
To start working:
Open ur VS.Net IDE and open a new solution
A ' New Project' windows will pop up in which u have to select 'Business
Intelligence project' folder and then select Report Project Wizard.
Hope this helps!
Good Luck,
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"Mark Goldin" wrote:
> After I installed Developer edition I can't find Reporting services report
> builder.
> How can I create a new report?
> Thanks
>
>|||But my understanding was that I dont need VS
do create reports in SQL 2005..
"Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
news:A751A3E8-C3A5-4126-ACF8-9B586A4FF472@.microsoft.com...
> It will be a add-in in your Visual Studio .net IDE.
> To start working:
> Open ur VS.Net IDE and open a new solution
> A ' New Project' windows will pop up in which u have to select 'Business
> Intelligence project' folder and then select Report Project Wizard.
> Hope this helps!
> Good Luck,
> Rajesh
> MCSD.NET
> http://meenrajan.blogspot.com
> "Mark Goldin" wrote:
>> After I installed Developer edition I can't find Reporting services
>> report
>> builder.
>> How can I create a new report?
>> Thanks
>>|||If Visual Studio is not already installed, a copy of the VS shell will be
installed to host the Report Designer and other SQL Server development tools.
This is what I got from MS documentation. I haven't tried it yet. someone
might help u.
Good luck,
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"Mark Goldin" wrote:
> But my understanding was that I dont need VS
> do create reports in SQL 2005..
> "Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
> news:A751A3E8-C3A5-4126-ACF8-9B586A4FF472@.microsoft.com...
> > It will be a add-in in your Visual Studio .net IDE.
> >
> > To start working:
> >
> > Open ur VS.Net IDE and open a new solution
> >
> > A ' New Project' windows will pop up in which u have to select 'Business
> > Intelligence project' folder and then select Report Project Wizard.
> >
> > Hope this helps!
> > Good Luck,
> > Rajesh
> > MCSD.NET
> > http://meenrajan.blogspot.com
> >
> > "Mark Goldin" wrote:
> >
> >> After I installed Developer edition I can't find Reporting services
> >> report
> >> builder.
> >> How can I create a new report?
> >>
> >> Thanks
> >>
> >>
> >>
>
>|||I dont think so.
"Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
news:80641113-FC1A-45EF-8D08-1FE1701733B9@.microsoft.com...
> If Visual Studio is not already installed, a copy of the VS shell will be
> installed to host the Report Designer and other SQL Server development
> tools.
> This is what I got from MS documentation. I haven't tried it yet. someone
> might help u.
> Good luck,
> Rajesh
> MCSD.NET
> http://meenrajan.blogspot.com
>
> "Mark Goldin" wrote:
>> But my understanding was that I dont need VS
>> do create reports in SQL 2005..
>> "Rajesh" <Rajesh@.discussions.microsoft.com> wrote in message
>> news:A751A3E8-C3A5-4126-ACF8-9B586A4FF472@.microsoft.com...
>> > It will be a add-in in your Visual Studio .net IDE.
>> >
>> > To start working:
>> >
>> > Open ur VS.Net IDE and open a new solution
>> >
>> > A ' New Project' windows will pop up in which u have to select
>> > 'Business
>> > Intelligence project' folder and then select Report Project Wizard.
>> >
>> > Hope this helps!
>> > Good Luck,
>> > Rajesh
>> > MCSD.NET
>> > http://meenrajan.blogspot.com
>> >
>> > "Mark Goldin" wrote:
>> >
>> >> After I installed Developer edition I can't find Reporting services
>> >> report
>> >> builder.
>> >> How can I create a new report?
>> >>
>> >> Thanks
>> >>
>> >>
>> >>
>>|||Report manager has a new button called "Report Builder" in the toolbar.
Clicking the button will launch the click-once installation and start Report
Builder. In the current CTP, you will need to have the .NET Framework 2.0
Beta 2 already installed on your client machine to run Report Builder.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uuk3IdSbFHA.3400@.tk2msftngp13.phx.gbl...
> After I installed Developer edition I can't find Reporting services report
> builder.
> How can I create a new report?
> Thanks
>|||Do you mean "Reporting services configuration manager"?
I dont see that button there.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23lMkpaWbFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Report manager has a new button called "Report Builder" in the toolbar.
> Clicking the button will launch the click-once installation and start
> Report Builder. In the current CTP, you will need to have the .NET
> Framework 2.0 Beta 2 already installed on your client machine to run
> Report Builder.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:uuk3IdSbFHA.3400@.tk2msftngp13.phx.gbl...
>> After I installed Developer edition I can't find Reporting services
>> report builder.
>> How can I create a new report?
>> Thanks
>|||No, I mean Report Manager. You will need CTP April or even better, CTP June
of SQL Server 2005 Reporting Services installed.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uhX1LvabFHA.1384@.TK2MSFTNGP09.phx.gbl...
> Do you mean "Reporting services configuration manager"?
> I dont see that button there.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:%23lMkpaWbFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Report manager has a new button called "Report Builder" in the toolbar.
>> Clicking the button will launch the click-once installation and start
>> Report Builder. In the current CTP, you will need to have the .NET
>> Framework 2.0 Beta 2 already installed on your client machine to run
>> Report Builder.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:uuk3IdSbFHA.3400@.tk2msftngp13.phx.gbl...
>> After I installed Developer edition I can't find Reporting services
>> report builder.
>> How can I create a new report?
>> Thanks
>>
>|||Report Builder can be launched from Report Manager (aka WebUI)
But it needs semantic model to be deployed on server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uuk3IdSbFHA.3400@.tk2msftngp13.phx.gbl...
> After I installed Developer edition I can't find Reporting services report
> builder.
> How can I create a new report?
> Thanks
>|||I have the June CTP installed and can see the Report Builder button. I
am trying to build a semantic layer pointing at a datasource other than
SQL Server, but the pull down listbox for Provider: has SQLClient Data
Provider selected and is disabled. Has anyone built a layer with
Oracle?

Reporing Services not responding

I am having a problem with Reporting Services. I had installed the developer
edition on my system and everything was working fine. Next day, turned my
system on and the report manager no longer responds. I can't access any of
the reports I had developed...nothing.
I am a newbie at reporting services but was making great progress learning
the product. The only indication of a problem I can find is in my event log.
I see that I am getting a SuperSocket bind failed on port 1433.
I have attempted removing and re-installing reporting services, as well as
to delete the reporting services databases but cannot seem to run this
product any more.
Can anyone help point me to what may be wrong?From the error message you are getting "SuperSocket bind failed on port
1433", i would say to have a look and see if your sql server is running
Med Bouchena
"Guy Thornton" <gt@.scd.com> a écrit dans le message de news:
5BEA585E-64F3-415B-A962-0B2F8DD210DD@.microsoft.com...
>I am having a problem with Reporting Services. I had installed the
>developer
> edition on my system and everything was working fine. Next day, turned my
> system on and the report manager no longer responds. I can't access any
> of
> the reports I had developed...nothing.
> I am a newbie at reporting services but was making great progress learning
> the product. The only indication of a problem I can find is in my event
> log.
> I see that I am getting a SuperSocket bind failed on port 1433.
> I have attempted removing and re-installing reporting services, as well as
> to delete the reporting services databases but cannot seem to run this
> product any more.
> Can anyone help point me to what may be wrong?
>|||Thanks for the suggestion Med. I actually thought the same thing. So I did
check my SQL Server installation. That is all working just fine.
I have also been able to track down in the HTTP logs that when I attempt to
access Report Manager, I am getting a 302 error.
"Med Bouchenafa" wrote:
> From the error message you are getting "SuperSocket bind failed on port
> 1433", i would say to have a look and see if your sql server is running
> Med Bouchena
> "Guy Thornton" <gt@.scd.com> a écrit dans le message de news:
> 5BEA585E-64F3-415B-A962-0B2F8DD210DD@.microsoft.com...
> >I am having a problem with Reporting Services. I had installed the
> >developer
> > edition on my system and everything was working fine. Next day, turned my
> > system on and the report manager no longer responds. I can't access any
> > of
> > the reports I had developed...nothing.
> >
> > I am a newbie at reporting services but was making great progress learning
> > the product. The only indication of a problem I can find is in my event
> > log.
> > I see that I am getting a SuperSocket bind failed on port 1433.
> >
> > I have attempted removing and re-installing reporting services, as well as
> > to delete the reporting services databases but cannot seem to run this
> > product any more.
> >
> > Can anyone help point me to what may be wrong?
> >
> >
>
>

replication, mirroring and log ship

dear all,

I have a case.

I have 1 production server and wanto to add 1 more server.

my production server is using sql 2000 stnd edition.

I want to have an indentical database from my production server.

the problem is my second server is using sql 2005 stnd edition.

I have try to use replication but because the my production database didn't have relationship on the database so I can't use transaction replication, I can't use mirroring and log ship too because the sql use the different version.

any idea or suggestion will be great....

regards,

-dedys

Transactional replication should work fine as it supports replicating between servers within two versions of each other.

Regards,

Matt Hollingsworth

SQL Server High Availability

|||

The only thing that would prevent you from using transactional replication is if you have tables that do not have primary keys.

As far as log shipping goes. You can configure log shipping from SQL Server 2000 to SQL Server 2005, because 2000 backups can be restored to 2005. You can not configure it the other way around.

|||

dear sir,

I already try to configure log ship on my server.

my primary server is on sql2000 and the secondary server is on sql 2005.

I find that on sql 2000 can't see the sql 2005.

do you have documentation regarding this. a web link ?

thanks

-dedys

|||You can't connect to and manage a 2005 instance from within Enterprise Manager. You can go the other way. Log shipping is nothing more than configuring jobs to backup the tran log, copy it to the secondary, and restore it on a recurring basis. From within Management Studio on 2005, you can point and click through the GUI and setup log shipping from 2000 to 2005. You can also just create three jobs manually and accomplish the same thing. I'm not sure what documentation you are looking for. The 2005 Books Online have step-by-step procedures for setting up log shipping.|||

hi,

I have tries to set log shipping from 2000 to 2005 but it seem can't be done.

example : Server A is 2005 and B is 2000

I'm using management studio from A and register B. but when I right click on the database B, I can't find log shipping.

so I can't configure log shipping from 2000 to 2005.

if you know how to set it. could you share it with me.

I also try to do it manually like you said. using 3 simple step.

step 1 and 2 is done. I have difficulties with step 3. that is restoring the transaction log.

do you know how to restore transaction log more that 2 files at the same time or the name is keep on changing ?

please advice

-dedys

|||You can't restore more than 1 tran log simultaneously. Just like you can't restore more than one of any backup at the same time to the same database. You have to restore 1 log and then the next and then the next etc.|||

hi mr michael,

I have tries but I still got problem.

the step that did,

restore fullbackup to other server.

then restore the transaction log one by one and at the last transaction log with recovery option.

that's part is ok.

but when I want add more transaction log, there is an error that said :

Msg 3117, Level 16, State 4, Line 1

The log or differential backup cannot be restored because no files are ready to rollforward.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

please advice

|||You have to restore all transaction logs using the NORECOVERY option. As soon as you recover the database, you can no longer restore tran logs.

replication, mirroring and log ship

dear all,

I have a case.

I have 1 production server and wanto to add 1 more server.

my production server is using sql 2000 stnd edition.

I want to have an indentical database from my production server.

the problem is my second server is using sql 2005 stnd edition.

I have try to use replication but because the my production database didn't have relationship on the database so I can't use transaction replication, I can't use mirroring and log ship too because the sql use the different version.

any idea or suggestion will be great....

regards,

-dedys

Transactional replication should work fine as it supports replicating between servers within two versions of each other.

Regards,

Matt Hollingsworth

SQL Server High Availability

|||

The only thing that would prevent you from using transactional replication is if you have tables that do not have primary keys.

As far as log shipping goes. You can configure log shipping from SQL Server 2000 to SQL Server 2005, because 2000 backups can be restored to 2005. You can not configure it the other way around.

|||

dear sir,

I already try to configure log ship on my server.

my primary server is on sql2000 and the secondary server is on sql 2005.

I find that on sql 2000 can't see the sql 2005.

do you have documentation regarding this. a web link ?

thanks

-dedys

|||You can't connect to and manage a 2005 instance from within Enterprise Manager. You can go the other way. Log shipping is nothing more than configuring jobs to backup the tran log, copy it to the secondary, and restore it on a recurring basis. From within Management Studio on 2005, you can point and click through the GUI and setup log shipping from 2000 to 2005. You can also just create three jobs manually and accomplish the same thing. I'm not sure what documentation you are looking for. The 2005 Books Online have step-by-step procedures for setting up log shipping.|||

hi,

I have tries to set log shipping from 2000 to 2005 but it seem can't be done.

example : Server A is 2005 and B is 2000

I'm using management studio from A and register B. but when I right click on the database B, I can't find log shipping.

so I can't configure log shipping from 2000 to 2005.

if you know how to set it. could you share it with me.

I also try to do it manually like you said. using 3 simple step.

step 1 and 2 is done. I have difficulties with step 3. that is restoring the transaction log.

do you know how to restore transaction log more that 2 files at the same time or the name is keep on changing ?

please advice

-dedys

|||You can't restore more than 1 tran log simultaneously. Just like you can't restore more than one of any backup at the same time to the same database. You have to restore 1 log and then the next and then the next etc.|||

hi mr michael,

I have tries but I still got problem.

the step that did,

restore fullbackup to other server.

then restore the transaction log one by one and at the last transaction log with recovery option.

that's part is ok.

but when I want add more transaction log, there is an error that said :

Msg 3117, Level 16, State 4, Line 1

The log or differential backup cannot be restored because no files are ready to rollforward.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

please advice

|||You have to restore all transaction logs using the NORECOVERY option. As soon as you recover the database, you can no longer restore tran logs.

replication, mirroring and log ship

dear all,

I have a case.

I have 1 production server and wanto to add 1 more server.

my production server is using sql 2000 stnd edition.

I want to have an indentical database from my production server.

the problem is my second server is using sql 2005 stnd edition.

I have try to use replication but because the my production database didn't have relationship on the database so I can't use transaction replication, I can't use mirroring and log ship too because the sql use the different version.

any idea or suggestion will be great....

regards,

-dedys

Transactional replication should work fine as it supports replicating between servers within two versions of each other.

Regards,

Matt Hollingsworth

SQL Server High Availability

|||

The only thing that would prevent you from using transactional replication is if you have tables that do not have primary keys.

As far as log shipping goes. You can configure log shipping from SQL Server 2000 to SQL Server 2005, because 2000 backups can be restored to 2005. You can not configure it the other way around.

|||

dear sir,

I already try to configure log ship on my server.

my primary server is on sql2000 and the secondary server is on sql 2005.

I find that on sql 2000 can't see the sql 2005.

do you have documentation regarding this. a web link ?

thanks

-dedys

|||You can't connect to and manage a 2005 instance from within Enterprise Manager. You can go the other way. Log shipping is nothing more than configuring jobs to backup the tran log, copy it to the secondary, and restore it on a recurring basis. From within Management Studio on 2005, you can point and click through the GUI and setup log shipping from 2000 to 2005. You can also just create three jobs manually and accomplish the same thing. I'm not sure what documentation you are looking for. The 2005 Books Online have step-by-step procedures for setting up log shipping.|||

hi,

I have tries to set log shipping from 2000 to 2005 but it seem can't be done.

example : Server A is 2005 and B is 2000

I'm using management studio from A and register B. but when I right click on the database B, I can't find log shipping.

so I can't configure log shipping from 2000 to 2005.

if you know how to set it. could you share it with me.

I also try to do it manually like you said. using 3 simple step.

step 1 and 2 is done. I have difficulties with step 3. that is restoring the transaction log.

do you know how to restore transaction log more that 2 files at the same time or the name is keep on changing ?

please advice

-dedys

|||You can't restore more than 1 tran log simultaneously. Just like you can't restore more than one of any backup at the same time to the same database. You have to restore 1 log and then the next and then the next etc.|||

hi mr michael,

I have tries but I still got problem.

the step that did,

restore fullbackup to other server.

then restore the transaction log one by one and at the last transaction log with recovery option.

that's part is ok.

but when I want add more transaction log, there is an error that said :

Msg 3117, Level 16, State 4, Line 1

The log or differential backup cannot be restored because no files are ready to rollforward.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

please advice

|||You have to restore all transaction logs using the NORECOVERY option. As soon as you recover the database, you can no longer restore tran logs.