This SSRS article shows how to replace the Nulls or empty values in a table report with custom values or text with an example. In real-time, it is better to display something other than empty rows. We can use a simple IIF condition with an IsNothing function to replace those Nulls. Right-Click on the Datasets … Read more
This SSRS article shows how to use the Switch case or statement inside an expression to change the background colors or create a new column with custom messages. Right-Click on the Datasets folder to create a new DataSet. The below screenshot shows the data set that we use for this SSRS Switch Statement example. The Sql query … Read more
This SSRS article shows how to use the IIF condition or expression to change the background colors or create a new column based on the existing one with custom messages. Right-Click on the Datasets folder to create a new DataSet. The below screenshot shows the data set that we use for this SSRS IIF condition … Read more
This SSRS article shows an example of how to hide table rows with Nulls or empty values. In real-time, it is annoying to see empty rows in a table report, and using a simple expression with the IIF condition will hide those Nulls. To work with this, right-click on the Datasets folder to create a … Read more
This SSRS article shows how to calculate the running Total for a table report using a RunningValue function with an example. It is one of the important interview questions one might face. First, right-click on the Datasets folder to create a new DataSet. The below screenshot shows the data set that we use for this … Read more
This SSRS article shows how to create a group on page table report without a wizard. It means creating a table report group by column; each group has to be displayed on a separate page. It is effortless to design a group on the page using a report wizard, but there is a workaround to … Read more
This SSRS article shows how to create a drill down table report with subtotals and grand totals with an example. It is effortless to design using a report wizard, but there is a workaround to create a drilldown report manually. Right-Click on the Datasets folder to create a new DataSet. The screenshot below shows the … Read more
This SSRS article shows how to create a drill down table using a enable drilldown option in the report wizard with an example. For this demonstration, we use the shared data source pointing to Adventure Works DW 2019. Create a Drill Down Table Using SSRS Report Wizard In the Solution Explorer, right-click on the Reports … Read more
This SSRS article shows how to display all the table rows or records on a single page. To work with this, right-click on the Datasets folder to create a new DataSet. The below screenshot shows the data set that we use for this example. The Sql query that we used above SSRS example is: SELECT Prod.EnglishProductName AS ProductName, Prod.Color, … Read more
This SSRS article shows how to use the parameters and display the user-selected parameter value inside a report. To do this, we have to add a Text Box and write an expression that calls the Parameter value. Right-Click on the Datasets folder to create a new DataSet. The screenshot below shows the data set we … Read more
