Working with Reporting Services Using Microsoft Sharepoint
page 3 of 3
by Ameet Phadnis
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 50473/ 70


This Article explains how you can display reports in SharePoint Portal details how you could create your own web part if the default web parts provided by SharePoint do not work for you. Going forward you could create Provider web part which would list all Reports under Reporting Services and Provide the Report Name as Cell for Report Viewer eb Part to consume it. Also, you could create your own Parameters web part which could provide a Row to consumer Report Viewer web part and display the Report. In short, there are lots of options that a developer can do to accomplish the displaying of reporting tasks on SharePoint Portal. The above logic does not hold true only for SharePoint Portal but you can use the same logic for ASP.NET Websites.

View Entire Article

User Comments

Title: test   
Name: guy
Date: 2012-12-06 11:42:16 AM
Title: Problem with Report which has size more then 100KB   
Name: Shalini
Date: 2010-07-26 1:32:34 AM
I have experiencing prolem in running RDLs which has size more then 100 kb. If I remove some of column from an rdl to make its size up to 100kb and then upload and run, it works fine.
I am able to upload rdl with size more than 100kb on share point 2010 site. But as I click to run or set data source, it gives error.
Title: Problem With Height Option   
Name: RS
Date: 2010-04-15 5:48:57 PM
I'm experiencing the same issue as Arvind. Whenever I set the default height to any value, the web part stops rendering 'Apply' button on the right side with parameters. Any suggestions?
Title: good article   
Name: abhishek
Date: 2010-04-09 6:45:37 AM
good,but need more snap shot.
Title: Windward Reports   
Name: David Thielen
Date: 2009-11-11 12:01:44 AM
For those looking for an alternative to SRSS, Windward Reports has a great plug-in to SharePoint that turns SharePoint into a great reporting, document generation, and dashboard server.
Title: Performance point and Sharepoint reports   
Name: Donovan
Date: 2009-10-26 4:11:22 AM
Has anyone ever used Performance Point to create reports for a share poin site?

If anyone knows how please let me know.
Title: Hiding View report button in SSRS   
Name: Anivesh
Date: 2009-08-07 11:17:00 AM
Hi All,

I do not want to show view report button of parameter field in SSRS. When I browse my report then every time i select a parameter i have to hit "View Report" button.
Is there any way to hide it...

Thanks in advance.....
Title: Problem With Height Option   
Name: Arvind
Date: 2009-07-29 12:57:21 AM
Hi Ameet,
I having a problem of using Report Viewer web part in Sharepoint Integrated Mode.Whenever I set it default height to some value like 800 pixels then it stops rendering 'Apply' button which comes by default on right side with parameters.
I even created a customized report viewer webpart using defaul report viewer as i have requirement of fetching the rdl file path from URL.In that case also 'Apply' button goes missing. Can you please help in this case .
Your help will be highly appreciated

Title: Have u came across date problems ?   
Name: Anoop Tripathi
Date: 2009-07-27 9:57:10 AM
i am developing reports using SSRS and displaying them on MS CRM sharepoint portal. But i have came across date problem.
the problem is that everything seems fine in report manager but gives error on sharepoint portal (the date related fields that is).
Title: good article   
Name: Neeraj
Date: 2009-03-09 8:52:23 AM
thanks for such a good article..
Title: the report is setup and running under a general account.   
Name: Desa
Date: 2009-01-27 12:07:04 AM
Hi Ameet
What if the report is setup and running under a general account.

How can i pass the credential onto the reporting server via an URL link or webpart?
Title: How to generate canned report in Sharepoint   
Name: Bala
Date: 2008-03-13 7:39:14 AM
I need to generate the canned reports in MOSS 2007.If anybody knows please give the steps.

Title: link with Sharepoint List   
Name: Bistesh
Date: 2008-03-04 7:46:48 AM
finally I got to link with the SP List items and web service with reporting viewer controls . We have to use the custom dataset to bind,.
Title: What Edition of MOSS   
Name: Imad Mansour
Date: 2008-02-29 8:27:21 AM
Excellent article.

just would like to know what edition of MOSS do we need to use reporting services EE or SE ???
Title: How to link with Sharepoint List   
Name: bistesh
Date: 2008-01-28 4:23:16 AM
Hi, Can you plz tell me that how to link the rdl file with the sharepoint list item so that I have to fetch the data from SP list and display in the report
Title: Images showing correctly for me   
Name: Brendan
Date: 2008-01-09 11:49:22 AM
I am not having any problems seeing the images.
Title: Images are not dispplaying properly   
Name: ramesh
Date: 2008-01-09 5:44:36 AM
Thanks for this good article.But at the same time pls find that the Images are not dispplaying properly(Images not found). Pls upload the images into proper folder. These are not displaying.
Title: beginner   
Name: anne
Date: 2007-08-15 9:02:44 PM
can u please tell me where i can view the Report Viewer and report explorer? i cant find them

thnx a bunch
Title: Beginner   
Name: max
Date: 2007-07-05 12:21:54 AM
Hi, i'm a beginner to RS and MOSS. Thanks very much for giving me a resolution for my problem. I had the same problem with connecting Explorer to Viewer. Setting the trust level to WSS_Medium solved the problem. Thanks a lot. Another question would be: when I try to set up RS/MOSS integrated mode rather than native mode, it gives me an error that it can't create a new database for Integration mode even though I am an admin on the box and have full rights on the MOSS server. Any ideas? I draw blank and no resources on the internet or Microsoft site. Thanks.
Title: how to use report viewer on sharepoint   
Name: Joe
Date: 2007-06-28 2:34:07 AM
Hi, I'm confused about how to display report in sharepoints. The problem is report manager is appears on report viewer web parts. my question is how to display report on sharepoints without report manager?
Title: Mr   
Name: VIral Shah
Date: 2007-03-22 7:59:55 PM
Hi, This is a very good artical, but can you help me with one question which will be really appreciated. I have added one text box on my report, can user enter the text during runtime and can get print of that. I need to do it. Can you Please Help me out. THank you. My Email Address Is:
Title: Where is the information entered on the ServerURL stored?   
Name: Tim Toennies
Date: 2007-02-06 12:46:32 PM
Do you know where this value is stored? Is it in SharePoint's Config database or some other file? I need to know because I want to change the setting for about 90 WebParts and I would rather not have to open each of them individually. Thanks very much for your help.
Title: RE: Having same issue as Gilles   
Name: Mike Knuth
Date: 2007-01-08 9:25:33 AM

You were correct. WSS_Minimal, doesn't seem to allow those Web Parts to connect up in MOSS. Modifying the web.config to change the trust level to WSS_Medium, took care of the issue.

Thank you.
Title: RE: Having same issue as Gilles   
Name: Mike Knuth
Date: 2007-01-03 6:31:37 PM
I installed the RSWebParts in the GAC. I thought they ran with full trust by default if they were in the GAC? Is there some other setting I missed?
Title: Having same issue as Gilles   
Name: Ameet
Date: 2007-01-03 4:17:50 PM
Did you try adjusting the trust level in your Web.Config file? Most probably that should fix it.
Title: Good Info: Having same issue as Gilles   
Name: Mike Knuth
Date: 2007-01-03 3:43:15 PM
Nice article. We used some of the information to create our own Web Parts to use on a dashboard. Thanks for the jumpstart!


Did you ever get your issue with connecting the Report Explorer and Viewer parts (in MOSS) squared away? I ran into the same thing this morning. You can put the viewer and explorer web parts on the same page and they work just fine. When you try to connect the viewer with the explorer, it blows up.

If you look in the Event Log, you might see something like: Request for the permission of type 'Microsoft.SharePoint.Security.SharePointPermission, Microsoft.SharePoint.Security, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed.

If you have any info, please post back. Thanks.
Title: Excellent Article   
Name: Gilles Urena
Date: 2006-12-19 5:40:16 PM
Great article. I have implemented on a MOSS platform and found out the connection b/w the explorer and the viewer is not working. Each web part is working individually.
Title: Excellent   
Name: Anwar
Date: 2006-11-30 1:28:26 AM
Ameet, Thanks for sharing your knowledge. This is indeed a wonderful article. I was quite confused since long, but this article has helped me in understanding and getting the things correctly. Thanks a lot buddy!
Title: Good article but ..   
Name: Patrick
Date: 2006-10-25 1:53:57 AM
I tried to follow the the exercise but its confusing when you mentioned :-
the best way is to web part is to convert the Report Viewer Web Control application provided with SQL Reporting Services. I have the ReportViewer application.But its not really clear in your article how to use it.How to convert that application to a web part? Some properties etc are missing with what you have on your article compared to whats in the application report viewer.
Title: Good article but ..   
Name: Patrick
Date: 2006-10-25 1:52:20 AM
I tried moving whats in the report viewer app to a WEB PART LIBRARY BUT I GET ERROR
"One of the properties of the Web Part has an incorrect format. Windows SharePoint Services cannot deserialize the Web Part. Check the format of the properties and try again."
Title: Problem with direct connection   
Name: A
Date: 2006-10-23 1:50:22 PM
Check the Web Parts which you created. Check if you are using the right web parts (Consumer or Provider)
Title: Problem with direct connection   
Name: Simone
Date: 2006-10-23 11:13:40 AM
Hi, I made the excercise but, the direct connection between Report Explorer and Report Viewer doesn't work! What is the possible problem?
Title: GoBack to Parent in WebPart   
Name: Hugo Eduardo Perez
Date: 2006-10-17 11:47:05 AM
It is a very good article. I need add GoBack to Parent button or control in WebPart in child reports for Go Back to de Parent Report, simmilar to Preview in report Designer. The Standar Button is Hide (in Internet Explorer).
It´s possible Go Gack to parent in WebPart Sharepoint ReportViewer?!!

Thanks, and if you could e-mail me any information you think helpfull @:
Thank You very much!
Title: Displaying the three parameters in a single row   
Name: Ameet
Date: 2006-10-11 5:06:40 PM
You need to write your own parameter control for that.


Title: Displaying the three parameters in a single row   
Name: Athmaram
Date: 2006-10-07 6:50:29 AM
Hi, I have an issue regarding displaying the 3 parameters in single row. by default sql reporting services display only 2 parameters in a row. Kindly help me how to display 3 parameters in a single row in report manager.(ie during preview or generating the report). Kindly send the suggestions to
Title: Bug in Jump to Url   
Name: Mugnaboa
Date: 2006-09-15 9:10:49 AM
I open my report in a iframe. I use a "jump to url" link in the report with the javascript code, i need to jump in a new window. It's not work!
Title: I couldn't use this in SPA2007   
Name: K K
Date: 2006-09-04 5:14:39 AM
I was able to use the settings mentioned in SPS2003 but not in 2007. I get the error while connecting explorer and viewer. Error message is Request for the permission of type 'Microsoft.SharePoint.Security.SharePointPermission, Microsoft.SharePoint.Security, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' failed
Title: Excellent   
Name: Aron Roberto
Date: 2006-08-29 9:37:36 PM
It is a very good article, I have to convert intranet to sharepoint, and I have no idea where to begin, even though your article was help full. can you please refer to me books or sites or any think you believe that can help me accomplish this project. Thanks, and if you could e-mail me any information you think helpfull @:
Thank You very much!
Title: I could'nt finish the example I had some errors   
Name: Heis
Date: 2006-07-10 2:15:06 PM
I made the exercise but, I had some error at the moment to ocmpile, this variable reportParameters what kind of type is it? In fact i did it in C#

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2023  |  Page Processed at 2023-09-29 9:57:53 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search