Posts Tagged ‘SSRS’


How to create cascading parameters in Reporting services (SSRS)

What is SSRS? SSRS stands for SQL Server Reporting Services. It is a reporting tool developed by Microsoft that comes free with the SQL Server. It produces formatted reports with the tables of data, graph, and reports. Reports are hosted on a server and configured to run using parameters supplied by users. When we run the […]

Time Well Spent in 2015

The end of 2015 is fast approaching, with December looming just a week away. For most people, December is packed with the hustle and bustle of last-minute gift shopping, or end-of-year projections and budgets for 2016. Often in the sway of all this activity, many are so focused on the approaching New Year that they […]

SSRS – Have you used it yet?

While there are several BI technologies and more coming into the foray every day, SSRS has remained a key player in this area for quite some time now.  One of the biggest advantages of SSRS reporting is that it involves the participation of the end user and that is very intuitive to use. Let’s go […]

Displaying Custom Messages in SSRS.

SSRS is a powerful tool not because it projects queries in really good looking charts but because it enhances user experience.  The reports are so intuitive that users can navigate and export data without much training.  However, as business analyst or data analysts or report designers, it is our responsibility to extend these usability features […]

Creating Table of Contents for SSRS reports

Table of contents have always helped readers to navigate through thick volume of books. This feature can be extended to our users in SSRS to navigate through several pages of reports. The table of contents in SSRS is called the document map. A document map is a clickable table of contents that takes the user […]

SSRS – Easy Hacks

In the past few weeks, we created variety of reports starting from simple tabular reports to colorful pie charts to user friendly drill down reports.   SSRS tool is very friendly and is developed to provide world class reports to the user community.  While browsing through several business intelligence forums, I found couple of questions that […]

Even Row Distribution on SSRS report

SSRS report tends to hold maximum number of rows it can fit on a page.  The number of rows varies according to the page size, row width, location of the table, etc.  My report contains 99 records and these records are unevenly distributed throughout the report.  The report I created holds 36 rows on page […]

Sales Report with Date Picker

Sales Report with Date Picker. Last week we created a generic sales report in SSRS.  This week we will customize that report and display the numbers only for specific dates.  Such reports are called Parameterized reports and are user friendly because the user can choose a date range for his/her reports. So, let us begin! […]

Sales Report in SSRS

I hope everyone has found my articles useful and have used my articles in creating some great looking SSRS reports.  This week we will take a look at creating a product breakdown report or a detailed sales report. Let us refresh our memory.  Our sales table has the following fields: Fields Description Data Type ID […]

pie chart

Pie Charts – Your First Visual SSRS Report

In my previous articles, we looked at all the basic concepts of creating a report in SSRS.  We built a simple tabular report and made it presentable.  However, simple tabular or matrix graphs are textual reports.   Today, we will build a visual report – a pie chart.  There are several visual reports one can build using […]

SSRS – Making Reports Presentable

Now that we have created out first SSRS report, it is time to make our reports presentable. SSRS is really user friendly and customizing a report is very simple. This is how our reports currently look:   Let us first add a title to the report so that the users/managers know what information to look […]

Creating First SSRS Report – Part 2

In this post, we are going to create our first report in SSRS.  Excited? Let’s get started. In order to create a report, we need 2 things: 1.)    Data source: Here, you make connection to your database in Microsoft SQL server, Oracle, Teradata, etc. 2.)    Dataset: Here, you choose your table you want to create […]

Load More