SQL Reporting :: How To Integrate SSRS Reports To Sharepoint 2010
Nov 12, 2010We have to integrate an SSRS report in sharepoint.When we will click on the report it should open in a custom aspx page and not under Report viewer.
View 1 RepliesWe have to integrate an SSRS report in sharepoint.When we will click on the report it should open in a custom aspx page and not under Report viewer.
View 1 RepliesWe have a requirement of using SSRS for rendering the reports using ReportViewer control. We are aware of the fact that SSRS requires Windows Authentication, but my requirement is to provide access to all the users stored in a database table who provide valid credentials to access the SSRS report via web page and report viewer cotrol.
We are following the below steps.
1) Create a dummy windows level user say "dummy".
2) Provide "Browser" permissions to the "dummy" user.
3) Set Impersonation = true for the "dummy" user in the web.config file of the custom website that uses the ReportViewer control.
4) Follow all the required steps to configure the reportviewer control for accessign the SSRS report
After following all the above steps we are successfully able to access the SSRS report on the internet facing website without any Windows authentication popup.
P.S. We dont want to implement a Custom extension for implementing forms authentication.
I don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty.
Technology
- SQL Server 2008 R2
- SharePoint 2010
how to integrate my asp.net application to sharepoint 2010?
View 3 Repliesdifferences between ssrs reports and crystal reports?
View 2 RepliesI have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.
View 3 RepliesI am using VWD 2008 with VB.Net code-behind. I have multiple parameterized RDLC reports that use tableadapters in a .xsd dataset that I use a reportviewer to view / export the PDF reports.
Lately, we have noticed that the reportviewer is causing many errors on our webserver and sometimes causing the webserver to crash. It has been recommended to me to move the RDLC reports to SSRS, which we also have up and running on another server.
My question is how do I do this? Do I have to convert them to RDL files? What about the fields on the .aspx pages that supply the parameters? Also, what do I do with the tableadapters?
We want to not use the reportviewer but still have the capability to retrieve the RDLC reports in PDF format.
Starting to look into an web app thet uses the ReportViewer to display SSRS reports. This is for SSRS 2008. What would be the best way to go about the follwoing: The reports are sales reports so only ceratin people will get to see certain reports.
1: If a user opens a report which they can see and that report has a subreport which they can't, will the subreport still be viewable?
2: If the webapp will be used by many different people internally and eventually by outside people, what is the best security startegy to use, just plain ServerReportCredentials passing, or something else?
1> "change the color of the background of report to the RGB (240, 240, 240)" and
2>change the background of the legend to "white" i am able to do the second requirement
I have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.
These reports can be called succesfully from both the report manager and my asp.net website.Everything has been working fine.
Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.
The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"
I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.
We currently have two web servers (Windows Server 2008 Standard, IIS7) setup to host an ASP.Net website and are using the basic features of our hardware firewall to provide network load balancing (NLB) between the two servers. This means we have had to change the ASP.Net session state mode to SQL Server in order to make the data stored in session accessible no matter which server responds to the request. The main issue now is that crystal reports (basic edition packaged with VS2008) do not seem to support serialization which is needed in order to store/transfer the report to session state on SQL Server.
From what I have read so far in order to get crystal reports working in a web farm environment it seems the only option is to upgrade to Crystal Reports Server and load the reports from a third server. Another option may be to use SQL Server Reporting Services (SSRS) as we already have this so no extra cost involved, however I'm not sure if SSRS would resolve the issue with storing reports in session?
i Have upgraded my Reports from Report server VS 2005 to VS 2008 .
My reports works fine in local, development & test server.
After Ugrading to 2008 it works fine in local server & devlopement serverr.
When i deployed to Test server i am trying to access my reports i am getting below errors,
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..
i checked the Datasource conncetion properties..its pointing to correct Test database only..
My reports are windows integrated...
Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.
Due to a recent hard disk failure, my company issued me Windows 7 (in part for certification testing as we begin to roll it out to the general employee base at the end of the year). As a result, I'm using vwd 2010, where I had been using vwd 2005. The existing site used the reportviewer 2005, but I'm finding it difficult to find information about editing those files in vwd 2010. Can anyone point me to the appropriate place or have some insight as to what must happen in order to manage 2005 reportviewer reports in vwd 2010? I have downloaded and installed the reportviewer 2010 add in. The site is using framework 2.0 even though the web servers are using 3.5 (One of the things I need to do is upgrade the site to 3.5, but I have a support issue to work on first.)
View 3 RepliesI have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
[Code]....
C# CODE :
[Code].... Opening SSRS 2008 report in VS 2010 with Report Viewer?
I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.
View 2 RepliesHow to integrate an external web ASP.NET control into a SharePoint application's page?
View 2 RepliesFollowing error comes when creating a WebPart In sharePoint 2010 Server.
Web Part Error: Unhandled exception was thrown by the user code wrapper's Execute method in the partial trust app domain: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'Microsoft.SharePoint.WebControls.SPGridView' from assembly 'Microsoft.SharePoint, Version=14.900.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at ListMenuSample.ListMenuSample.ListMenuSample.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.ExecuteHttpRequest(SPUserCodeWebPartHttpRequestContext webPartExecutionContext, SPUserCodeWebPartHttpResponse httpRequestResponse) at Microsoft.SharePoint.UserCode.SPUserCodeWebPartWrapper.Execute(SPUserCodeExecutionContext executionContext) at Microsoft.SharePoint.UserCode.SPUserCodeApplicationHostAppDomainRef.Execute(Type userCodeWrapperType, SPUserCodeCachedAssemblyGroup userAssemblyGroup, Guid siteCollectionId, Byte[] binaryUserCodeToken, Byte[] proxyOperationToken, SPUserCodeExecutionContext executionContext)
Being new to integrating sharepoint documents into web applications I am struggling with the following task, so anyI have a page in my web application that needs to display a document from sharepoint.I use the appropiate sharepoint web service to get a list of all the documents in the sharepoint list, I then pick out the one I would like to retrieve and get the path to the document so i would end up with something like:
Company%20Hire/Hire%20Site%20Price%20Lists/0.pdf
Within our network I can do following:
iframePdf.Attributes[
"src"] = ConfigurationManager.AppSettings["SharepointUrl"] + _filePath;
This would display the document in iframe... problem I have is coming from outside the network the sharepoint site can't be accessed (due to firewalls etc). We do have a vpn back to our network on the external server our web application sits on. If i was to use the document url in a browser on the server I am prompted for credentials and then get to view the document.Is there a way for the web application to use the vpn, use credentials i give (e.g through impersonation) to access the document and display it to exernal clients?
Iam working on a banking web application developed in asp.net 3.5 and MS SQL Server 2008.My problem is to create reports including some pre-formatted reports,summary reports and some detail reports.I want to know what is the best technique to create these reports.I don't want to use third party reporting tools as they have to be configured on the web server and some times they takes lot of time in generating reports due to their complex structure.Since its a web application having large recordsets so i need a consistent solution keeping in mind the performance and complex nature of the reports which might be demanded by the banks.Can anyone help me please in this regard?
View 2 RepliesI am using ssrs 2008. My Report can generate 5000 Record count , 10000 Records count or more than 10000 records count.
When i am rendering large reoport above 10, 000 record count i am getting timeout Exception error.
how can i avoid that exception..?
i read through some forum can genarate one report into mulitiple reports by dividing the record count.
how best i can work on Rendering Large reports.
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 RepliesI am doing a SSRS report to generate some kind of print outs.
I need to have different footers inside the whole print out.
e.g. After first several pages I need to use page number as page footer( this can be easily done). but after that i need have footers as Annex A -1, Annex A-2, or Annex B -1 , Annex C - 1, when the page is Annex A, Annex B...etc.
what would be the user name and password of http://localhost/Reports to access SERVER 2005 Reporting service
View 7 Replies