All articles: Data Visualisation

Checkout our self-help content, created by our top Experts!
Datasets in SSRS – Querychat
Datasets are essential when it comes to developing reports in SSRS. They represent objects which allow us to display a set of data in our report. It is important to emphasize that datasets don’t contain the data itself, but information on how to fetch a particular dataset from a database....
Setting row color in SSRS – Querychat
While developing SSRS reports, we strive to build a report that is visually more attractive to a user. In case we have table incorporated within a report, we can boost the attractiveness and readability of a report table by changing default row colors. In order to explain how to set...
Report Items in SSRS – Querychat
Report items serve as visual building elements of SSRS report. There are various kind of report items available in SSRS. We can see the list of the items in the Toolbox: Figure 1: Available report items in SSRS If Toolbox tab is not visible by default, we can display it...
Round function in SSRS – Querychat
Round function is widely used to manipulate decimal numbers. It serves us to display a decimal number rounded either to a desired precision scale or to the nearest integer number. In SSRS, round function is a part of common function group which can be used through expressions. The syntax of...
Case statement in SSRS – Querychat
Case statement is one of a widely used program flow statements. It allows us to control the program flow and it’s outputs when we have more than two flows/conditions to set. In essence, case statement is an optimized version of nested If statement. In SSRS, case statement is a decision...
Tables in SSRS – Querychat
Table is one of the most important building elements in SSRS. It is used to display data in two-dimensional format consisting of rows and columns. A table can be put in a report in two ways: Drag-and-drop a Table report item from Toolbox tab Figure 1: Table item in Toolbox tab...
Subreports in SSRS – Querychat
Subreports are very useful tool in creating a reports in SSRS. They allow us to display one report in another. This functionality is very useful if we want to display graphs/tables developed in one report as a part of another, more complex report. This way we don’t have do duplicate...
Data formatting in SSRS – Querychat
End-user experience is a very important thing to be taken care of when it comes to data reporting. If we want our report to be accepted and utilized by users, we need to format it in the way that it is clear and easy to use. This article explains how...
Parametrized reports in SSRS – Querychat
Parametrized reports are a default in today’s world of reporting. It enables the user to browse through the data more easily and to filter only the subset of the data they need at the moment. In order to explain the usage of parameters in reporting, we will first display a...
If statement in SSRS – Querychat
If statement is a widely used program flow statement. It allows a developer to control the program flow and it’s outputs. In SSRS, If statement is a decision function that can be reached through expressions. Important thing to mention is that in SSRS, a keyword for If statement is IIf,...