Report drilldown still a major issue - HotFix needed!

While testing the latest RC1 SRS software and trying to get report drill down
in a chart working, I found that it was not working as expected. I thought
that this might be a Dundas issue, but has since learned that this is a MS
issue.
I understand that MS is aware of this and I strongly believe that this needs
to be fixed via HotFix rather than waiting until release time or later. We
are working towards a Spring 2006 release of our software and report
drilldown is one of the most important elements of our application.
Has anyone else ran into this issue?
Thanks!
KeithThis sound like you need a fix. I would contact Microsoft Product Support
Services. If it is indeed a fix and not user error, all fees are refunded.
If you specific details on what the bug is, I can look it up and see if it
is fixed if it is something we know about.
bradsy@.microsoft.com
--
| Thread-Topic: Report drilldown still a major issue - HotFix needed!!
| thread-index: AcXERUgoHQxmMZhhRD29mQIbnrU+Aw==| X-WBNR-Posting-Host: 66.89.74.203
| From: "=?Utf-8?B?S2VpdGg=?=" <Keith@.discussions.microsoft.com>
| Subject: Report drilldown still a major issue - HotFix needed!!
| Date: Wed, 28 Sep 2005 08:57:09 -0700
| Lines: 14
| Message-ID: <E55E5CE0-899D-46CA-87F2-11F58CAF6787@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53277
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| While testing the latest RC1 SRS software and trying to get report drill
down
| in a chart working, I found that it was not working as expected. I
thought
| that this might be a Dundas issue, but has since learned that this is a
MS
| issue.
|
| I understand that MS is aware of this and I strongly believe that this
needs
| to be fixed via HotFix rather than waiting until release time or later.
We
| are working towards a Spring 2006 release of our software and report
| drilldown is one of the most important elements of our application.
|
| Has anyone else ran into this issue?
|
| Thanks!
| Keith
|sql

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 Designer doesn't work

Hello everybody
I have some problems with the report designer in visual studio 2003. When
I'm working on a new report project and I had defined my data source and my
data sets, and I had have a report made, if I want to change my report (for
example: create a new list or table or try to modify some property of an
element) when I go to view the report with the new changes, this changes are
not in my report.
Well, then I open the .rdl file to see if the changes are in the script but
they aren't.
The only way I found to make the changes in my report is to open the .rdl
file directly (with the notepad, for example), and write the new properties.
Can anybody help me? It's very strange because the report designer works in
the begining of the project but It doesn't work from a moment untill the end.
I have to delete all the project and make all again.I haven't run into this myself, but I would only make the obvious suggestion
of installing all service packs for Reporting Services. (SP2)
--
Shaun Beane, MCT, MCDST, MCDBA
dbageek.blogspot.com
"Aritz" <Aritz@.discussions.microsoft.com> wrote in message
news:641F3656-356A-4236-BEB7-349C023105D7@.microsoft.com...
> Hello everybody
> I have some problems with the report designer in visual studio 2003. When
> I'm working on a new report project and I had defined my data source and
> my
> data sets, and I had have a report made, if I want to change my report
> (for
> example: create a new list or table or try to modify some property of an
> element) when I go to view the report with the new changes, this changes
> are
> not in my report.
> Well, then I open the .rdl file to see if the changes are in the script
> but
> they aren't.
> The only way I found to make the changes in my report is to open the .rdl
> file directly (with the notepad, for example), and write the new
> properties.
> Can anybody help me? It's very strange because the report designer works
> in
> the begining of the project but It doesn't work from a moment untill the
> end.
> I have to delete all the project and make all again.|||What are you changing? I am on RS 2005 but I used RS 2000 and have never
seen this. The only thing I have seen is that sometimes making a change to a
dataset is not picked up if you exit without first going to layout and
clicking the save button. What happens is the dirty bit is not being set, RS
designer does not know that the dataset design changed. So, I got used to
clicking on the save button every time I made a change.
Other than that though, you should not be having any problems.
One question, are you changing the rdl directly while in VS or are you using
the visual designers.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aritz" <Aritz@.discussions.microsoft.com> wrote in message
news:641F3656-356A-4236-BEB7-349C023105D7@.microsoft.com...
> Hello everybody
> I have some problems with the report designer in visual studio 2003. When
> I'm working on a new report project and I had defined my data source and
> my
> data sets, and I had have a report made, if I want to change my report
> (for
> example: create a new list or table or try to modify some property of an
> element) when I go to view the report with the new changes, this changes
> are
> not in my report.
> Well, then I open the .rdl file to see if the changes are in the script
> but
> they aren't.
> The only way I found to make the changes in my report is to open the .rdl
> file directly (with the notepad, for example), and write the new
> properties.
> Can anybody help me? It's very strange because the report designer works
> in
> the begining of the project but It doesn't work from a moment untill the
> end.
> I have to delete all the project and make all again.|||Did you try hitting the refresh button? If I make a change and rerun Ive had
times where the same thing I ran the last time came back unless I hit refresh
button.
"Bruce L-C [MVP]" wrote:
> What are you changing? I am on RS 2005 but I used RS 2000 and have never
> seen this. The only thing I have seen is that sometimes making a change to a
> dataset is not picked up if you exit without first going to layout and
> clicking the save button. What happens is the dirty bit is not being set, RS
> designer does not know that the dataset design changed. So, I got used to
> clicking on the save button every time I made a change.
> Other than that though, you should not be having any problems.
> One question, are you changing the rdl directly while in VS or are you using
> the visual designers.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Aritz" <Aritz@.discussions.microsoft.com> wrote in message
> news:641F3656-356A-4236-BEB7-349C023105D7@.microsoft.com...
> > Hello everybody
> > I have some problems with the report designer in visual studio 2003. When
> > I'm working on a new report project and I had defined my data source and
> > my
> > data sets, and I had have a report made, if I want to change my report
> > (for
> > example: create a new list or table or try to modify some property of an
> > element) when I go to view the report with the new changes, this changes
> > are
> > not in my report.
> > Well, then I open the .rdl file to see if the changes are in the script
> > but
> > they aren't.
> > The only way I found to make the changes in my report is to open the .rdl
> > file directly (with the notepad, for example), and write the new
> > properties.
> > Can anybody help me? It's very strange because the report designer works
> > in
> > the begining of the project but It doesn't work from a moment untill the
> > end.
> > I have to delete all the project and make all again.
>
>|||Hi Bruce, thank you for your answer (and to everybody)
One of the properties I try to change is to add a reference of a custom
assembly and for this I use the visual designer. If I add the reference with
the report properties window, it doesn't work. For example I try to change
the author of the report whith the report properties window, I write a new
author and y acept the changes and then the window closes. I open the same
window again and the author's name is empty. If I want to change really the
autor of the report y have to write the changes directly in the .rdl file.
"Bruce L-C [MVP]" wrote:
> What are you changing? I am on RS 2005 but I used RS 2000 and have never
> seen this. The only thing I have seen is that sometimes making a change to a
> dataset is not picked up if you exit without first going to layout and
> clicking the save button. What happens is the dirty bit is not being set, RS
> designer does not know that the dataset design changed. So, I got used to
> clicking on the save button every time I made a change.
> Other than that though, you should not be having any problems.
> One question, are you changing the rdl directly while in VS or are you using
> the visual designers.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Aritz" <Aritz@.discussions.microsoft.com> wrote in message
> news:641F3656-356A-4236-BEB7-349C023105D7@.microsoft.com...
> > Hello everybody
> > I have some problems with the report designer in visual studio 2003. When
> > I'm working on a new report project and I had defined my data source and
> > my
> > data sets, and I had have a report made, if I want to change my report
> > (for
> > example: create a new list or table or try to modify some property of an
> > element) when I go to view the report with the new changes, this changes
> > are
> > not in my report.
> > Well, then I open the .rdl file to see if the changes are in the script
> > but
> > they aren't.
> > The only way I found to make the changes in my report is to open the .rdl
> > file directly (with the notepad, for example), and write the new
> > properties.
> > Can anybody help me? It's very strange because the report designer works
> > in
> > the begining of the project but It doesn't work from a moment untill the
> > end.
> > I have to delete all the project and make all again.
>
>sql

Report Builder, Getting Started Pane: OK greyed out

Hi all,

I'm working on a new SSRS implementation, and have created a Report Model against an SSAS database. I launced Report Builder and can see and select the model in the list, but the OK button at the bottom of the pane is greyed out so I'm unable to actually start building a report against it. Any ideas on what I need to change to make the button work? I have already verified that I have full access to the data source as well as the model, in addition to the underlying SSAS DB, so I don't believe it is a permissions issue... But I'm certainly open to any suggestions.

Thanks!

You are probably running into this (from http://support.microsoft.com/kb/899825):

In Report Builder, when you select a report model that was generated from an Analysis Services cube, you must select a perspective that is contained within the model. You must not select the top-level model itself. If your report contains items that are not within a single perspective, an error may occur when you try to render the report.

Brian

Report Builder only for sql 2005 server?

Hello,

i'm working with SQL Server 2000. And management wants some reports out of the SQL server.

Now there is a product called Report Builder with is a tool to easly create reports. My question is where can i download Report Builder for SQL Server 2000?

Report Builder only comes with Reporting Services 2005. You can use it to access data in SQL 2000 etc but you will need a SQL 2005 licence to use Reporting Services 2005\Report Builder.

Do management want to build their own reports or just view some standard reports? In the latter case Reporting Services 2000 is what you need and this is a free download once you have a SQL 2000 licence.

|||

They want there own reports. They have created some excel sheets to show these information. I have found a plugin for excel to read informatie directly out OLAP CUBE.

But the problem is that you only can view these excelsheet only when you have this plugin installed.

So i'm looking for a way to generate report on the intranet. Like with report services only the problem is to create the report as a duplicate of the excel sheet. That why i wanted to use report builder.

sql

Report Builder not working with Forms Authentication

We have successfully implemented forms authentication. The ReportServer and Report Manager both are working fine. However, when we launch the ReportBuilder using the url http://<server-name>/ReportServer/ReportBuilder/ReportBuilder.application or from the Report Manager, it prompts for user name and password. On entering the valid user-name and password, it gives the following error.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

It doesnt accept any user-name, password (neither forms one, nor windows). This error is when we are trying to access Report Builder on the server (not tried on the client machine). The user-name has been given System Administrator and System User role. We have also given the Content Manager, Browser, ... etc all roles to the user.

However, we are testing this on June CTP. Is this a problem ?

This is very urgent as the rest all is working fine. Any suggestions ?

Thanks in advance.

Is there any solution? Does Report Builder work with Forms Authentication ?|||

If I remember correctly, this was a bug that we fixed before the RTM release of RS 2005. If you upgrade to RTM - or better yet, to SP1, this should work.

Thanks

Tudor

Report Builder not working - Us Too

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working - Us Too

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

Report Builder not working

Hi, Running RS2005 (was running RS2000 on same system)
When trying to run Report Builder I am getting the following error;

Report Execution Error

The report might not be valid or the server could not process the data.

An attempt has been made to use a rendering extension that is not registered for this report server.

Anyone come across this error before?

Thanks in advance

Scott

anywhere I can go to get an answer to this. Excuse the pun but this renders Report Builder useless

Advaned thanks to anyone who has any idea

Scott

|||

We are getting same error on our shop. Have you found resolution yet?

|||

nothing from anyone....if you find anything I would appreciate anything you find.

I have searched high and low.

One person on another forum said the following;

'Did you upgrade from RS2000 to RS2005? If so, prior to the upgrade, did you have any custom controls or third party controls you may have bought installed? That error message to me seems to say that the report is trying to show a control for which a dll (control source) does not exist. This would lead me to believe - based on you saying RS2000 worked before - that when you did an upgrade, you did not setup these custom controls. '

Maybe it might help

Scott

|||

I spent at lot of time on Friday getting the SelfSSL working on the system. It was set up with the name of the computer, I managed to get it working with ComputerName.domain.com/local etc.

I have just come back to Report builder and it now works!! I am writing this just incase it gives you a clue to how I managed to get it working

Thanks

Scott

sql

Report Builder - Filter Dropdown Order Post 2005 SP2 Incorrect

Hi All,

Hope someone can help here. Since installing Service Pack 2 onto our SQL 2005 instances our report models are not working correctly. When selecting fields within the models as filters, and getting them to prompt when the report is run, the ordering of the data within the filters does not match the selected ordering in the model definition. The ordering is random each time the report is run.

This issue does not happen when setting the filter up, the data appears in the correct order, but when running the report the filter data is incorrect.

I have spent the last 4 hours building a new system and testing this with each stage of service packing. The RTM version of SQL 2005 is ok, SP1 is also OK, but when SP2 is applied the ordering fails.

Any ideas?

Many thanks in advance.

Regards

Nick

An update to this issue just in case it may help others.

I logged a call with Microsoft relating to this issue and the product support specialist managed to reproduce the issue at their end. It was passed up to the product teams and the reponse has come back that it is now designed this way even though it worked prior to SP2.

The specific issue is:- Dropdown parameter boxes on reports created using report builder do not adhere to the ordering specified in the report model at runtime, although they do at design time.

As we were adding parameter boxes allowing users to select from almost 1000 branch codes the fact that it isn't ordered and appears in a random order is obviously an issue that has meant we can no longer use report builder.

The workaround suggested by Microsoft is to index the underlying tables so that the table scans of the branch codes scan indexes instead and return ordered lists, as the index is already ordered. Unfortunately I cannot do this as my tables are indexed for performance, and I can't change them to fix an issue that shouldn't (in my personal opinion) be there in the first place.

Hope this helps anyone else in the same situation.

Nick

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

I'm very experienced with SQL Server, but new to reporting services. I'm
currently working with the Report builder, and I'm having a hard time trying
to get it to work as I need.
From my web app, I'm able to put a link on there for ad-hoc reports.
Clicking it opens the report builder. The models are available to pick from
to build the report. (The app authenticates with a sql server account)
What I want is to have a different default "home" for each ananlys that
creates an ad-hoc report. These homes would be private. I also want to let
each analyst share their ad-hoc reports with whoever they choose.
Can I do this with Reporting services?I believe you can. Making the Home folder private is posible by creating a
folder for each analyst and only give permissions to each analyst to access
their own folder.
Now, for the analysts to share the reports they create, you will have to
create another folder with the connections so all the models from all
analysts will use the same connection(s).
The users may share their reports by saving them to their machines or in a
share drive. Let me know if you need to instructions on how to save reports
in your local machine.
"Steve" <ss@.Mailinator.com> wrote in message
news:e8iT3mNBHHA.4680@.TK2MSFTNGP04.phx.gbl...
> I'm very experienced with SQL Server, but new to reporting services. I'm
> currently working with the Report builder, and I'm having a hard time
> trying to get it to work as I need.
> From my web app, I'm able to put a link on there for ad-hoc reports.
> Clicking it opens the report builder. The models are available to pick
> from to build the report. (The app authenticates with a sql server
> account)
> What I want is to have a different default "home" for each ananlys that
> creates an ad-hoc report. These homes would be private. I also want to
> let each analyst share their ad-hoc reports with whoever they choose.
> Can I do this with Reporting services?
>

Report Automation

hi

i have created a rss script for report deployment which i working pretty good but icheckout my all reports on report server and from another machine i mapped that drive from command line and run rss script then i got following error

================================================================

:\Automation>rs -i PromotionAutomation.rss -s http://fsaleem/reportserver -v en
v=Dev -v DBServer=fsaleem

Unhandled Exception: System.TypeInitializationException: The type initializer fo
r "Microsoft.ReportingServices.ScriptHost.ScriptHost" threw an exception. > S
ystem.Security.SecurityException: Request for the permission of type System.Secu
rity.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral
, PublicKeyToken=b77a5c561934e089 failed.
at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet granted
Set, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permT
oken)
at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
unrestrictedOverride)
at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, S
tackCrawlMark& stackMark)
at System.Security.CodeAccessPermission.Demand()
at System.Reflection.Assembly.VerifyCodeBaseDiscovery(String codeBase)
at System.Reflection.Assembly.GetName(Boolean copiedName)
at System.Reflection.Assembly.GetName()
at Microsoft.ReportingServices.ScriptHost.ScriptHost..cctor()

The state of the failed permission was:
<IPermission class="System.Security.Permissions.FileIOPermission, mscorlib, Vers
ion=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
version="1"
PathDiscovery="Z:\Automation\RS.exe"/>

End of inner exception stack trace
at Microsoft.ReportingServices.ScriptHost.ScriptHost.Main(String[] args)

================================================================

I think what's happening here is that the CAS security in .NET reduces the security privileges because you mapped the drive. If you add the mapped location to the trusted sites in IE does it work? It should work if you copy the files locally.

Report and Query Design

Hi all - have finally got reporting services working and am wondering how I would go about designing an order form. I have 2 tables - order and orderline.

Would it be best to design a query which got all information in one retrievale (so that orderid is repeated on each record retrieved) or 2 seperate queries and therefore use a subreport - the main report having the order details and the subreport containing all the orderlines.

Thanks in advance,

Stephen.

The best way to do this by using subReport or drillthrough report where you get the main data in the first report and each row will navigate to the sub report and get the detials fro great start and sample

please read this is article it also contains great sample

http://www.gotreportviewer.com/

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?
> >
> >
>
>