Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 149 of 212

137 C H A P T E R 7 | Better reporting Report server When you select the Report Server option, you select a specific report server and then navigate folders on the server containing data sources. Click a folder tile to display the data sets it contains and then select the data set tile to import its data into your mobile report. Note The first time you select the Report Server option, the Connect To A Server prompt is displayed. In the Server Address box, type /reports, replacing the token with the name of the server hosting Reporting Services. Do not include the http:// prefix. If the report server is not configured to use Secure Socket Layer (SSL), clear the Use Secure Connection check box. If the data set uses a database login instead of Windows authentication, or if you want to use a different Windows account, clear the Use Current Windows Account check box and supply the applicable credentials. Working with Excel Data To import data from Excel, your file must have been created using Excel 2007 or later and must be saved with the .xlsx file extension. You can import only one worksheet at a time. Column headers are recommended but are not required. The import process will automatically assign one of the following data types to each column: string, double (numeric), Boolean (true/flase), or datetime. You should ensure that each column contains the same type of data in each row. Otherwise, the data- type assignment on import may not be correct. Numbers should not be formatted with currency or other symbols. Your data can contain formulas, but the import process resolves the formulas and imports only values. Mobile Report Publisher automatically configures two properties for imported data when it detects a date/time column. You can override these properties by clicking the gear charm on the data view tab and then clicking the Dates charm. On the Set Date/Time Settings page, shown in Figure 7-17, you can select a specific column in the Date/Time Filter Column drop-down list (if there are multiple date/time columns available) instead of keeping the default value of Auto, which uses the first date/time column in the data view. You also have the option of choosing another level of granularity, such as Months or Weeks, in the Aggregation Time Unit drop-down list. Figure 7-17: Configuring the Date/Time settings for a data view. After importing data into a mobile report in Mobile Report Publisher, you can then connect each data set to mobile report elements. To do this, first select an element in the Control Instances pane to the left of the data view. Then, in the Data Properties panel below the data view, select the data view to assign (by name) from the applicable drop-down list for the selected element. As an example, use the Series For Background Chart drop-down list to assign a data set to a time navigator element, as shown in Figure 7-18. The options that are displayed in the Data Properties panel, including the name of the data view drop-down list, vary by mobile report element.

Articles in this issue

Archives of this issue

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