Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Chapter 9Advanced Queries and Parameters

WHAT'S IN THIS CHAPTER?

• Understanding T-SQL queries and parameters
• Understanding MDX queries, parameters, and expressions
• Understanding DAX queries, parameters, and expressions
• Managing report parameters
• Using parameter expressions

Chapter 5, “Database Query Basics,” introduced you to query and report parameters. This chapter introduces you to a few simple techniques to parameterize queries. The discussion in this chapter steps through the design of each sample report, and then delves deeper into less-common and more advanced design patterns.

The parameter architecture in Reporting Services has remained the same since the product's inception. But recent enhancements in SQL Server 2016 give you control of the parameter placement in the parameter bar displayed at the top of the browser. In this chapter, you see how to define specialized parameter items you can use to return all (or a range of) dataset records with a single parameter selection. Many of the same techniques can be used with MDX queries for SQL Server Analysis Services (SSAS). However, you will need an understanding of the unique needs and capabilities of the MDX language and query objects.

NOTE

Unlike in previous chapters, this chapter does not walk you through every step of the included exercises, but provides the necessary instructions to apply the skills you have acquired in the previous chapters.

T-SQL QUERIES AND PARAMETERS

As the native query language ...