Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

sql

Report Viewer/Explorer-WebPart missing under SharePoint v3+SQL Server 2005

Hello all,

I'm new with SP v3 and the Reporting Services of SQL Server 2005.

I did a prototyp report and show it with "SQL Reporting Services
Report"-WebPart, but I can't find the WebParts Report Viewer and
Explorer in the WebPart Gallery.

Please, could somebody give me a clue where the problem could be, or
how I could isolate the problem area.

Cheers
Marc

Salut Marc,

If you seach the keyword "web parts" in the help module you will find how to add the SSRS web parts ...

Try this dos command

--

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab"

--

Regards

Ayzan

|||

Hello Ayzan,

thanks a lot for your help - works fine!

The only thing i wonder is that the stsadm-console-tool did deploy the webparts through the CAP-File, but neither do the webparts appear after the "add webparts" view nor do they reside in the webparts library under site settings.

When I do the stsadm -o enumwppacks command the webparts are listed!

So did I miss something...is there another procedure now in SP v3, or is it a further security setting?

Thanks again!

Cheers,

Marc

|||

You did not miss something ... Bill did ;-)

Click on "Modify the workspace" and 'Add Wep Parts".

When the right zone appears click on "Create Lists" and "Browse".

Choose "Virtual Server Gallery" ... and it should be there ...

Regards

Ayzan

|||

Hey Ayzan,

I got it...really amazing usability...its all so intuitive...good effort, Bill :D!

U are the man:)

Have a nice day,

Marc

|||

Sorry, I forgot to ask you if you already have a documentation for Sharepoint v3, or some useful links?

Cheers

Marc

|||

Nop, we are working on a test platform, so we didn't spend time on writing a documentation. But you can post your questions, I will try answer.

Regards

Ayzan

|||

Hello Ayzan,

how are you?

For me, I'm still not sure about the most reasonable way to go, although I'm dealing with SSRS for about 3 weeks.

The requirements for the our reporting system are:

1.-Reports depend on the current user (e.g. choice of report parameter, rights)
2.-Reports consist of a comprehensive collection of different paramater types
3.-OLAP/Cubes will be applied
4.-Ad-Hoc Reports should be offered (Report-Builder might be to complex and too less user-friendly for users)

My outcome for now:

Report Viewer Control looks like a possible "out-of-the-box" solution, but

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

Thanks a lot for any help!

Cheers,
Marc

|||

Hi Marc,

First of all, don't think that I am a Sql 2005 expert, I am just a project manager. My team and I, have been working on Sql 2005 for 3 months now, so as to build dashboard portal prototype, using SSAS for the cubes, SSRS for reporting, and Sharepoint services as web framework.

->how does it enable me to fulfil point (1)? How can I dynamically exchange data between code behind and the report viewer control? Have only seen the property expressions with link to web.config, .resx and sql connection.

We manage security and access to dimension occurrences through SSAS roles.

->is it possible to adjust/customize the layout of the parameter bar (e.g. not only background-color, but also positions, free text and pictures)?

Good question, if you find how, please tell me ;-)). I know that some new features will be implemented with the SP1, I hope it will be one of them

->what are K.O. criterias for the report viewer control so that I need to code the whole thing via API?

Wouuu, humm ... I don't know

->Report Builder is too complex for end-users, so the report system itself must be quite generic and flexible, or is there another way to go?

We don't use Report Builder, because there is no real added value. Currently, excel (pivot tables with SSAS connection) seems to be the best solution. Avoid to use the SSAS Excel Plugin. You can also check solutions like Temtec

|||

Ayzan, thanks for your quick reply:)

If i get it right you "just" apply the out-of-the-box reporting via Report Viewer WebPart and define and manage all the security and access issues already before in the backend by SSAS roles.

Does this mean you are satisfied with the customization of the parameter area for the users and also you don't have any user-specific parameter-item choices so that there is no reason to apply the Report Server WebService API?

I have already thought about the excel-pivot tables with SSAS solution, but haven't had time to do enough research or rather develop a prototype, but probably it would be worthwile to dive deeper into this.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Which impacts has SSAS regarding performance, flexibility, effort and maintenance?

If you like, I'll send you my white-papers and presentations about the research and prototype-work I'll do in the following weeks:)

Cheers

Marc

|||

As you said, we "just" apply the SSRS/SSAS comon framework. But remember, that we work on a prototype, the real BI project will begin soon. So, my users are satisfied with the current interface as they didn't have any bi application before.

What are for you the real benefits and biggest problems applying SSAS with cubes/dimensions/partitioning after you are working with these issues for a while?

Well, in my opinion, we did not investigate SSAS features as deep as I expected. Although SSRS and SSAS cover more than our real needs, the biggest problem, I have, is that I can't find a SSAS/MDX expert (2005 version) ... and I am desesperatly expecting SSAS step by step book ;-). Nevertheless, we manage to set up 4 cubes, easaly, with partitioning, security, without coding a line of mdx and with no data mining (next step).

Concerning maintenance and felxibility, remember, it's a prototype ;-). Our 4 cubes contains 2 partitions (hsitory and current month), and the current month partition is reprocessed twice a day, and from now we never experienced a problem ...

I will be glad to read you whitepapers and presentations.

Regards

Ayzan

|||

Hi ,

Can any one help me to create a webpart which is a report explorer for WSS using asp.net. If you any code snippet can you help me out with this.

regards

Sahu

Report Viewer web part in Sharepoint 2.0 site

Hello:
I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
to display a report when a page loads using just the page viewer web
part.
In the properties of the web part, I have http://portal:81/Reports/Pages/Report.aspx?
in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
+Sellers in the Report Path field.
When I hit apply, the web part displays "A required argument is
missing from the URL that opens this page: ItemPath".
What am I doing wrong here?
Any assistance is appreciated.
Thanks in advance.
-JoeNever mind. I had the report server URL incorrect (it should have
been just http://portal:81/reports) and the report path should have
just been /repvendorportal/Top Sellers. The + was causing a problem
too.
Thanks.
-Joe
On Nov 8, 1:14 pm, Joe <j...@.josephmarkovich.com> wrote:
> Hello:
> I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
> to display a report when a page loads using just the page viewer web
> part.
> In the properties of the web part, I havehttp://portal:81/Reports/Pages/Report.aspx?
> in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
> +Sellers in the Report Path field.
> When I hit apply, the web part displays "A required argument is
> missing from the URL that opens this page: ItemPath".
> What am I doing wrong here?
> Any assistance is appreciated.
> Thanks in advance.
> -Joe

report viewer web part error

I'm having problems with the SharePoint configuration on a REport Viewer web
part. When Report Explorer and Report Viewer are used together, all is fine.
This is just trying to configure Report Viewer as a stand alone web part.
My direct URL path to a report is:
http://server01/Reports/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority
In the Report Manager URL box, I have http://server01/Reports.
In the Report Path box I have:
/Pages/Report.aspx?ItemPath=%2fCorporate+Applications%2fOpen+Requests+By+Priority.
I get the Reporting Services Error in the Report Viewer web part:
"The path of the item
'/reportserver?%2fCorporate+Applications%2fOpen+Requests+By+Priority&rs:Command=Render'
is not valid. The full path must be less than 260 characters long, must start
with slash; other restrictions apply. Check the documentation for complete
set of restrictions. (rsInvalidItemPath) "
Of course the doc just tells me my path is too long, which it's not.
Any ideas?
Thanks,
PaulI have the same problem...did you figure out a solution? If so, can
you send it to me at ram.pisipati@.lmco.com
Thanks
Ram|||Hi,
I got the same error !
solution:
just enter the folder name from reporting service
i.e. /AD+Site+Reports
Torsten
ram.pisipati@.lmco.com schrieb:
> I have the same problem...did you figure out a solution? If so, can
> you send it to me at ram.pisipati@.lmco.com
> Thanks
> Ram|||Not sure I understand you correctly. Where do you want me to enter the
folder name?
the report viewer web part takes two parameters and this is what I am
entering for each of the parameters
Report Server path: http://www.myserver.com/Reports/?
Report path: /TestFolder/TestReport
Thanks in advance
Ram

Report Viewer web part (sp2)

Does anyone know how to pass parameters through to the Sharepoint
Report Viewer web part?
Thanks,
Paul.Go to the site:
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
It's give some advices. I hope that will help you

Report subscription to sharepoint

I want to setup a subscription for a report to be copied out to a sharepoint
site. Is this possible? If so, then how do I do it?Hello DilWorth,
If you could use the UNC path to access the Sharepoint Site, you could
setup a Fileshare subscription to copy the report to the sharepoint site.
File Share Delivery in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms159264.aspx
Also, if you want the user to see the report in the sharepoint site, you
could apply the reporting services web part for sharepoint.
The webpart is located C:\Program Files\Microsoft SQL
Server\90\Tools\Reporting Services\SharePoint. You could install the
webpart and implement it in the site.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am interested in the webpart that you speak of that is located in
C:\Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint.
I went to a presentation that Microsoft did for our company on SRS. They
did a demo on how to post reports to SPS. When asked about the webpart, they
said that as long as you had SP2, this part should appear in our gallery of
webparts. It does not.
When Microsoft was over at my company doing a Business Scorecard
presentation, I asked the developer that said this to come to my desk and
"show me". It wasn't there. He said I did not have SP2. I verified that
the files in a Q article that indicated whether or not one had SP2 were
there; they were. So, it would appear that I have SP2; however, I cannot
locate this webpart. Once I do located it, how do I install it? Do you have
some advice or a Q article or two you could point me to?
Thanks!
-Eleanor
"Wei Lu [MSFT]" wrote:
> Hello DilWorth,
> If you could use the UNC path to access the Sharepoint Site, you could
> setup a Fileshare subscription to copy the report to the sharepoint site.
> File Share Delivery in Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms159264.aspx
> Also, if you want the user to see the report in the sharepoint site, you
> could apply the reporting services web part for sharepoint.
> The webpart is located C:\Program Files\Microsoft SQL
> Server\90\Tools\Reporting Services\SharePoint. You could install the
> webpart and implement it in the site.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||I was able to get the rswebparts.cab installed and able to the part to a
page; however, when I am trying to connect to reporting services, the show
report in function is grayed out.
Do I have some sort of permission issue?
Thanks!
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Report Services: The server commited a protocol violation

Can anyone help with this problem?

I have a green light on my Report Services Confuration, and can configure the server within sharepoint integrated mode. I have also assign the appropriate permission for aspnet etc..etc.

From within Business Intelligent studio when I tried to publish my reports I get the below error:

The server commited a protocol violation

Here is a copy of the report server services log file.

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__main_06_21_2007_10_47_38.log</Path>
<SystemName>DMTXDW01VM2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!21/06/2007-10:47:39:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!21/06/2007-10:47:46:: i INFO: Total Physical memory: 1073094656
ReportingServicesService!servicecontroller!4!21/06/2007-10:47:47:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'

Urgent help required!

Have you tried adding this to the web.config file?

<system.net>

<settings>

<httpWebRequest useUnsafeHeaderParsing="true" />

...

|||

Hi Tau Liang,

Many thanks for the help, but unfortunatly it did not help! Is the above to go into the Report Manager or Report Services web configuration file or other?

Randine

Report Server and Sharepoint Services

Hello,
Is there some problems between ReportServer and Sharepoint services ?
I have two servers in Win 2003 Server. On is PDC and the second is a
standalone server.
On the first, I have activated Sharepoint services before installing
ReportServer. And ReportServer doesn't work.
On the second, I have installed ReportServer before Sharepoint Services.
ReportServer was working very well before I activate Sharepoint Services.
Do you know some issue about this 2 products ?
ThanksHave you excluded the Reporting Services sites from the SharePoint Portal
Server site?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp
Maybe this helps?
Kaisa M. Lindahl
"Gael Le Mouhaer" <gael.lemouhaer@.linum.fr> wrote in message
news:XnF95B58A945327Bgaellemouhaerlinumfr@.207.46.248.16...
> Hello,
> Is there some problems between ReportServer and Sharepoint services ?
> I have two servers in Win 2003 Server. On is PDC and the second is a
> standalone server.
> On the first, I have activated Sharepoint services before installing
> ReportServer. And ReportServer doesn't work.
> On the second, I have installed ReportServer before Sharepoint Services.
> ReportServer was working very well before I activate Sharepoint Services.
> Do you know some issue about this 2 products ?
> Thanks

Report Refresh through code in reporting services

I use some editor to edit the data in the backend. I view the report in sharepoint portal using url access of the report in reporting services with the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data of the report using an editor, I want the report to be updated with the new data. This I want to do it by placing a button or some link in the Sharepoint, clicking which should update the report with the new data. Is there any parameter like rc:refresh which will refresh the report?
--
Message posted via http://www.sqlmonster.comYes, rs:ClearSession=true will refresh the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Varma via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9fcebb16b4f6418fb26b01a1a4841f5d@.SQLMonster.com...
>I use some editor to edit the data in the backend. I view the report in
>sharepoint portal using url access of the report in reporting services with
>the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data
>of the report using an editor, I want the report to be updated with the new
>data. This I want to do it by placing a button or some link in the
>Sharepoint, clicking which should update the report with the new data. Is
>there any parameter like rc:refresh which will refresh the report?
> --
> Message posted via http://www.sqlmonster.com