Data for Reporting Services mobile reports

The SQL Server Mobile Report Publisher data model is simple. Data is imported into Mobile Report Publisher as a collection of datasets. Formal relationships between datasets aren't necessary. Lookups from one dataset to another work as long as the key values match. Date/time aggregations are handled by the mobile report runtime and they will match between different datasets, even if the date/time data granularity is different between datasets.

You can import data from two types of sources:

  • Local Excel files: Select an Excel document and pick which worksheet(s) to import. After import, the data is stored within the mobile report definition. To refresh the data from the original Excel file, use the Refresh Data command in the upper-right corner on the Mobile Report Publisher Data tab. Read more about preparing Excel data for SSRS mobile reports.

  • SQL Server Mobile Report Publisher shared datasets: Browse the list of published datasets on the server and select the ones to add to the mobile report. Mobile reports based on server data always stay connected to the original server datasets and reflect the latest state of the data on the server. See a list of supported data sources.

    Read more about getting data from shared datasets in Mobile Report Publisher.

After you import data into Mobile Report Publisher, the rest of the mobile report creation and design experience is the same, regardless of where the data came from.

Connect mobile report elements to data

Each SQL Server Mobile Report Publisher element contains one or more data settings. For example, the Radial Gauge element contains two data settings: Main Value and Comparison Value. Each of these settings points to exactly one field (column) in a specific dataset.

The mobile report runtime provides aggregated values for the gauge, based on user selections. Note that the Comparison Value of the same Radial Gauge instance can be bound to a field from a different dataset.

See also