In that case, a drop-down list is displayed. All other types use a plain input box, unless values are provided in the Available Values page. Date-type parameters use a calendar picker control, and Boolean-type parameters display a pair of radio buttons to facilitate selecting either True or False values. Certain data types (such as Date and Boolean) change the input control displayed in the parameter bar. The “Data type” should be set to Integer instead of the default Text-Setting “Data type” to match the filtered field can be more efficient. Inspect the report parameter in the Report Data window and note the following properties (as shown in Figure 9-2): Figure 9-1 shows the Parameters page of the Dataset Properties dialog where the report parameter, ProductKeys, is mapped to the dataset parameter having the same name.įIGURE 9-1: Parameters page of Dataset Properties dialog. Starting with the dataset, let’s work from the inside out. These two objects have the same name, so they can be easily confused, but it is important to understand the difference. When this query is executed in the designer, the ProductKeys parameter is added to the report, and a corresponding dataset parameter is created. Inner join dbo.Product p on s.ProductKey = p.ProductKey SELECT s.OrderDate, s.SalesOrderNumber p.ProductCategory p.ProductSubcategory, p.ProductName p.ProductKey p.StandardCost p.ListPrice, s.OrderQuantity, s.SalesAmount The ProductList dataset uses the following query:Īnother dataset, named ReportDate, uses the following query: The Ch09 – Parameter In List report has two datasets: one to populate a parameter list, and one for the main report query. Out of the box, you get several sample reports and instructions to demonstrate different parameter techniques (such as using parameter lists, simple and multi-select parameters, inter-dependent cascading parameters, and so on). NOTE U n l i k e 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.Īs the native query language of Microsoft SQL Server, Transact-SQL (T-SQL) provides a great deal of flexibility and many creative ways to dynamically filter datasets with parameters. However, you will need an understanding of the unique needs and capabilities of the MDX language and query objects. Many of the same techniques can be used with MDX queries for SQL Server Analysis Services (SSAS).
#SSRS DATA TOOLBAR HOW TO#
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. 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. The parameter architecture in Reporting Services has remained the same since the product’s inception. 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. This chapter introduces you to a few simple techniques to parameterize queries.
#SSRS DATA TOOLBAR PROFESSIONAL#
This post is part of the series: “ Professional SSRS 2016 Book Preview Posts” which are excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports.
0 kommentar(er)
