Difference between report builder and report designer

Report Builder is a web-based tool to create reports. Report Builder is assessable through the Report Manager so the reports developed are bydefault stored in the Server but reports developed using Report designer of BIDS available in MS Visual Studio can be stored as RDL Files in the local or can be stored in the server. There is no compulsion as such. Report Builder is basically used by the end-users for developing some basic reports with little features as compared to the large functionality of Report Designer in BIDS which is mainly used by developers. A report builder looks more … Click here to continue…..

Types of SSRS Reports

Parameterized reports: When the output of a report is not static but instead depends on the input parameters supplied to the reports at run time, the report is known as a Parameterized report.Drillthrough reports, linked reports, subreport and all other report types are a kind of Parameterized reports. Linked Report: A linked report is a report server item that is derived from an existing report and retains the original report’s definition. A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, … Click here to continue…..

SSRS Reporting Lifecycle

To understand the needs of a reporting platform, you need to first understand the reporting lifecycle. Reporting platforms can be evaluated by their support for the following areas: authoring, management, and delivery. You look at each of these phases later to see how Reporting Services implements them. This Figure shows the basic reporting lifecycle. Authoring Authoring is the process of creating and publishing reports. There are two primary methods of report development: end user developed reports and report analyst developed reports. There are some distinct differences between these two methods. End user developed reports generally require a much simpler interface. … Click here to continue…..

Authentication types supported by (SSRS) Reporting Services

All users or applications who request access to report server content or operations must be authenticated using the authentication type configured on the report server before access is allowed. The following table describes the authentication types supported by Reporting Services. AuthenticationType Name HTTP Authentication Layer value Used by default Description RSWindowsNegotiate Negotiate Yes Attempts to use Kerberos for Windows Integrated authentication first, but falls back to NTLM if Active Directory cannot grant a ticket for the client request to the report server. Negotiate will only fall back to NTLM if the ticket is not available. If the first attempt results … Click here to continue…..