In one of the ASP .Net site we are currently working we have a bulk load of SSRS reports. We have forms authentication for the site and reports have already been created and deployed in the report server. We are having so many problems with authentication when we set the report viewer control to access the server report.
I just want to know what are the advantages or disadvantages of using Local report vs Server Report
Thanks,
Raja
Q: What is the difference between RDL and RDLC formats? A: RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2008 version of Report Designer. RDL and RDLC formats have the same XML schema.
The SSRS Report Builder is a report creation tool which allows users to create, manage and publish reports to SQL Server Reporting Services. We can also create shared datasets with the help of the report builder.
Report server items are always stored in libraries or in a folder within a library.
The ASP.NET ReportViewer control is a composite of standard ASP.NET Web Server controls. The ASP.NET ReportViewer comes with four predefined skins: Default, WebBlue, Original and Office2007. The ASP.NET ReportViewer control's toolbar is immutable.
1- client report don't need to report server for rendering. (advantage)
2- you must make a server report by creating a report server project in BIDS but client reports must create in VS.
3- server reports use stored procedure or text script as data provider but client reports use dataset or xml datasource for this.
4- server reports use report server for rendering of the report but for client reports this work done at report viewer control.
5- client reports don't need SSRS installation but server reports need that.
6- for working with server reports you must deploy reports but in client reports you don't need this work.
7- for enterprise projects, it is better that you use server report but in other projects client reports are better.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With