Skip to content

get-data-from-shared-datasets-in-reporting-services-mobile-reports.md

Latest commit

 

History

History
61 lines (36 loc) · 4.26 KB

get-data-from-shared-datasets-in-reporting-services-mobile-reports.md

File metadata and controls

61 lines (36 loc) · 4.26 KB
title Get data from shared datasets in Reporting Services mobile reports
description SQL Server Mobile Report Publisher can access data from almost any source by using a shared data source, configured on a Reporting Services web portal.
ms.date 09/25/2024
ms.service reporting-services
ms.subservice mobile-reports
ms.topic how-to
ms.custom
updatefrequency5
sfi-image-nochange

Get data from shared datasets in Reporting Services mobile reports

[!INCLUDE ssrs-mobile-report-deprecated]

Besides loading data from Excel files, SQL Server Mobile Report Publisher can also access data from almost any source. Accessing data requires a shared data source, configured on a Reporting Services web portal. Read more about creating shared data sources and creating shared datasets.

After shared data sources and shared datasets are configured on the Reporting Services server, you can use them in mobile reports you create in [!INCLUDEPRODUCT_NAME].

After you connect to a [!INCLUDEPRODUCT_NAME] server from the [!INCLUDEPRODUCT_NAME], connecting a mobile report to a shared dataset is straightforward.

  1. On the Data tab, select Add Data.

  2. Select Report Server.

  3. If you're connecting to the server for the first time, fill in the server name and your name and password. Put the server name in the Server address box in this format:

    <servername>/reports/

    As in this example:

    :::image type="content" source="../../reporting-services/mobile-reports/media/ssmrp-connecttoserver.png" alt-text="Screenshot of the screen used to connect to the server.":::

  4. When you select the [!INCLUDEPRODUCT_NAME] server, you see the available datasets in folders. Select a dataset to import the data into [!INCLUDEPRODUCT_NAME].

    :::image type="content" source="../../reporting-services/mobile-reports/media/ss-mrp-serverdata.png" alt-text="Screenshot of the available datasets you can import.":::

After you import the dataset, you can design your mobile report just as you would with simulated data, or local data from an Excel file.

By default, the shared dataset is always up to date with the latest data. The dataset is up to date because every time someone views a mobile report based on that dataset. SQL Server runs the underlying query and returns the latest data. Clearly, if lots of people view your mobile report this result might not be ideal, so you can set up caching to run the query periodically and cache the resulting dataset. This blog post explains how caching and data refresh works in the web portal.

Add, edit, or remove a report server

If you're already connected to a report server, when you select Add Data on the Data tab, you don't see an option to add another report server. Follow these steps instead.

  1. In the upper-left corner, select Connections.

    :::image type="content" source="../../reporting-services/mobile-reports/media/ssmrp-addconnectionicon.png" alt-text="Screenshot of the Connections button to open the Server Connection pane.":::

    The Server Connection pane opens.

    :::image type="content" source="../../reporting-services/mobile-reports/media/ssmrp-serverconnectnpane.png" alt-text="Screenshot of the Server Connection pane.":::

  2. Add a new server connection, or edit or remove existing connections.

Related content