Blog

Q. What is SSRS? 1. SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. 2. It …

SSRS Tutorial This tutorial gives you an overview and talks about the fundamentals of SSRS. What is SSRS? SQL Server Reporting Services is a reporting tool t…

Deploying Reports Reports can be deployed either individually, or as part of a complete project deployment. In this tutorial, you will deploy the complete proj…

SSRS Indicators Indicators are a visual way of assigning categories to values. In the same way that conditional formatting in Excel might be used to highlight …

Adding charts to a report Charts add visual appeal to a report and can quickly elevate a report from looking just like a spreadsheet of data to powerful tool f…

Sparklines Sparklines are small charts that you can embed into cells of a table or matrix. Because of their size they do not show labels or a legend, although …

Matrix Reports A Matrix is very similar to a table, but it is configured to show data grouped by columns and rows, with aggregate data at the intersections. So…

Adding totals and subtotals In this Try it, the report from the previous section is modified to add totals to each grouping level, make the different grouping …

Grouping data for multi-level reports In the same way that drill-down reports allow a user to select a category and then run a report to view details of indivi…

Creating drill down reports – Part 1 Drill-drown reports are one way of linking two or more reports, so that one report shows summary information and a second …

Using Parameters to make Dynamic Reports Fixed reports that show current data are very useful, but even more useful is the ability to build reports that allow …

Expressions and number formatting As well as the standard text formatting options, you can format the style of numbers and dates. To get to these more advanced…

Formatting the table Producing a functional table that displays basic data is quite straightforward, but displaying data straight from the database doesn’t alw…

Display data in a table The most basic way to display information on a report is to use a simple table. You create a table by simply dragging it from the toolb…

Create a report dataset A dataset is usually specific to a report and will be based on a query to the database. Datasets are added to a report by right-clickin…

Creating a report with a shared data source You now have a Shared Data Source in your project, but no dataset or report to display any information. Remember th…

Data Sources and Datasets When you are building reports, it’s likely that you will want to design more than one as part of the same project. For example, you m…

SSDT is a Microsoft application which is based on Visual Studio, but is configured for use with Microsoft’s Business Intelligence line of products such as SSRS,…

What is SSRS? SQL Server Reporting Services is a reporting tool that comes free with SQL Server 2012. With SSRS you can produce formatted reports with tables o…