SSRS

Getting Started With SQL Server Reporting Services (SSRS) – Part 4


Overview

Hi Friends! This is fourth article of the series Getting Started With SQL Server Reporting Services (SSRS). In previous three articles we learned following

  • How to create Simple Report using SQL Server Reporting Services?
  • How to show data in Table Control from database?
  • How to create parameterized reports?
  • How to set visibility for report controls?
  • How to show chart in reports?

For those who have not read previous articles they can read it from these links :

Getting Started With SQL Server Reporting Services (SSRS) – Part 1
Getting Started With SQL Server Reporting Services (SSRS) – Part 2
Getting Started With SQL Server Reporting Services (SSRS) – Part 3

Now, Some times we need to display data of multiple report into one single report. To achieve this instead of creating complete new report, all datasets we can use SubReport Control of SSRS to add multiple sub reports in a main single report. In this article we will learn how to use SubReport Control in our report to reduce our designing and development work. I hope if you are reading all articles of this series then you are almost used to with my Report Project 1 Solution.

So let’s start with our previous Report Server Project 1 Solution.
(more…)

Advertisements

Getting Started With SQL Server Reporting Services (SSRS) – Part 3


Overview

Hi friends! This is the third article i am going to write for this series of Getting Started With SQL Server Reporting Services (SSRS). In my first article of this series we saw how to start with SQL Server Reporting Services, requirements for SQL Server Reporting Services, Installation and we have created one simple report. For those who have not read this article they can read the same from here Getting Started With SQL Server Reporting Services (SSRS) – Part1 .
In my second article we saw how to create parameterized reports, how to format report data and how to set visibility for different report controls using various expressions. You can read this article here Getting Started With SQL Server Reporting Services (SSRS) – Part 2 .

Now, In this article we will see how to add chart control in our report. I am using here the same Solution of Report Server Project to make it simple to understand. (more…)

Getting Started With SQL Server Reporting Services (SSRS) – Part 2


Overview

Hi friends! In my previous article we learned how to create a simple report using Microsoft SQL Server Reporting Service (SSRS). In that we used a simple SQL Statement to display data from a SQL Database in our report. For those who have not read my previous article, they can read it from Getting Started With SQL Server Reporting Services (SSRS) – Part 1. So now in this article we will learn how to create parameterized reports using SSRS, some basic data formatting concepts and how to set visibility for report controls. I am using here the same Solution of Report Server Project to make it simple to understand. (more…)

Getting Started With SQL Server Reporting Services (SSRS) – Part 1


Overview

sql server

Microsoft SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of a suite of Microsoft SQL Server services. The SSRS service provides a unique interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. SSRS also provides a “Report Builder” tool for less technical IT workers to format SQL reports of less complexity. It provides a full range of ready-to-use tools and services to help you create, deploy and manage reports for your organization. Reporting Services includes programming features that enable you to extend and customize your reporting functionality. With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. Reports can include impressive data visualization, including charts, maps and sparkle. You can publish reports, schedule report processing, or access reports on-demand. You can select from a variety of viewing formats and export reports to other applications such as Microsoft Excel and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. You can also create data alerts on reports published to a SharePoint site and receive email messages when report data changes. (more…)