Filters:

  • Technologies

  • Instructors

  • Blog Author Archives: PeterAvila

    How to Display the Elapsed Processing Time of a Report in SSRS

    The amount of time it takes to process a report can be useful information for performance auditing. Although there isn’t a built-in field in SQL Server Reporting Services that holds the elapsed processing time, it’s easy to create this functionality using the ExecutionTime built-in field and the Now VB.Net function in SSRS. For instructor-led SQL … Continue reading How to Display the Elapsed Processing Time of a Report in SSRS

    Optional Parameters in SSRS

    Let’s say you have a report, like a sales report that shows sales orders, and some people who run that report need it to show only the one sales order that they specify while others need to see all sales orders. In this article, I’ll show you how to create an optional parameter that allows … Continue reading Optional Parameters in SSRS

    A Real-World Example of a Non-Correlated SELECT Subquery and Cross Join

    I recently developed a solution to a problem that is a good example of a non-correlated subquery in a SELECT clause that can also be written as a cross join. I’ll describe the requirement, the data, and then the solution with a non-correlated subquery and another with a cross join. To keep my client and … Continue reading A Real-World Example of a Non-Correlated SELECT Subquery and Cross Join

    Using Custom Code in SSRS

    While expressions allow you to use limited VB.Net to create advanced dynamic functionality in your SQL Server Reporting Services (SSRS) reports, custom code allows you to leverage much more of the power of VB.Net. The focus of this article is not on writing VB.Net code, but on how to create and use code in SSRS. … Continue reading Using Custom Code in SSRS

    How to Display Blanks as Zeros in a SSRS Report

    Some of the cells in this SSRS matrix report are blank: To display zeros instead, we will use two functions: 1.

    2.

      In the design of the matrix, right-click on the textbox containing the values in question, then select Expression… to edit the expression underlying the textbox. Type the following expression in … Continue reading How to Display Blanks as Zeros in a SSRS Report

    A Primer on Joins

    The golden rule of OLTP database design is that every table should represent one, and only one, entity-type. Without this rule, databases can exhibit three data anomalies (insertion, deletion, and update anomalies) that undermine data integrity. But adherence to the rule comes at a price of greater overhead (though it is a price well worth … Continue reading A Primer on Joins