Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 145 of 212

133 C H A P T E R 7 | Better reporting Note When you add a report parameter by using the Parameters pane, the parameter is added automatically to the Report Data pane. You can easily access a parameter's properties by double- clicking it in either location. After adding a parameter, you can drag it to a new location. Consider using empty rows or columns to create groupings of parameters, as shown in Figure 7-11. Figure 7-11: Using separate columns to group parameters in the Parameter pane. Note If you design a report with cascading parameters, the sequence of parameters in the Report Data pane remains important. Cascading parameters are a set of at least two parameters in which a child parameter's available list of values is dependent on the user's selection of another parameter value, the parent parameter. The parent parameter must be displayed above the child parameter in the Report Data pane. You cannot control the size of an unused parameter column, but the rendered report displays each column with enough separation to clearly distinguish groups, as shown Figure 7-12. You can create more separation between column groups by inserting another empty column in the Parameters pane. Figure 7-12: Parameter groups in a rendered report. Mobile report development Mobile reports display data concisely for use on mobile devices. The acquisition of Datazen by Microsoft brings a suite of tools supporting the development of mobile reports into the Reporting Services platform. To create mobile reports, you use the SQL Server Mobile Report Publisher. Note You can download the Mobile Report Publisher from us/download/confirmation.aspx?id=50400 or from the Microsoft Store if you are using Windows 8 or Windows 10. You can also download it from the Reporting Services web portal. Mobile reports enable you to create data mash-ups from a variety of data sources. You can use the same data sources and shared data sets published to the report server to connect data to mobile report elements such as gauges and charts, among others. Introducing the mobile report designer When you open Mobile Report Publisher, you see the Layout tab, which contains an empty design surface with 5 rows and 10 columns, as shown in Figure 7-13. You add various elements to the design surface to compose your report and can use slider controls above the design surface to resize the grid as needed.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016