SQL Server 2016 and Windows Server 2016 Better Together Technical white paper (April 2016) published by Microsoft “Microsoft is pushing the limits of hardware capabilities and bringing the latest enterprise technologies to market. Both products are offering improvements to availability and disaster recovery features, providing an unprecedented level of interoperability in a variety of environments.” … Continue reading Microsoft White Paper – SQL Server 2016 and Windows Server 2016 Better Together
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
Plenty of IT professionals are looking to start or expand their certifications. If you’re interested in pursuing Microsoft certification, now is a great time! Microsoft periodically runs a Second Shot promotion. What it means is that if you don’t pass your first attempt at an exam, Microsoft gives you a free retake of that exam. … Continue reading Microsoft Second Shot Exams Are On!
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
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
In this article I’ll show you how to configure a table tablix to both repeat column headers at the top of every page and freeze them while scrolling. While tablixes have properties for these things, they only work in matrix tablixes but not in tables. I’ll show you a way to accomplish these things using … Continue reading Repeating and Freezing Column Headers in SSRS Tables
Let’s say we have the following report that shows total sales by product category by territory: When we export this report to Excel, we’d like each territory to appear in its own worksheet and each worksheet named after its territory: How do we make this work? Easy! 1) Put every group on its own page, … Continue reading How to Name Worksheets When Exporting SSRS reports to Excel
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
Are you working towards your SQL Server 2012 Microsoft Certified Solutions Associate (MCSA) credentials? If so, you now have more options for your exams. Starting on 15 September 2014 there are now electives for your MCSA certification. There are now 2 required exams and a choice of 1 elective from a list of 4 exams … Continue reading Microsoft announces changes to SQL Server 2012 MCSA Certification
Some of the cells in this SSRS matrix report are blank: To display zeros instead, we will use two functions: 1.
IsNothing(<Val2Check>) returns a True of Val2Check is Null; otherwise, it returns False
IIF(<Test>, <IfTrue>, <IfFalse>) return <IfTrue> if <Test> is True; otherwise, it returns <IfFalse>
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