Exporting a report to RDL output in Management Reporter

Microsoft Office PerformancePoint 2007 Management Reporter can export a report from the report library to a Report Definition Language (.rdl) file or to RDL output in SQL Server Reporting Services (SSRS).

The file name that you specify must end in .rdl. This file name is an index file from with you can access all report contexts (financial, account, transaction, and exception).

Given below is the procedure to export a report to RDL output:

  1. In the navigation pane, click Report Library, and then double-click a report name.

  2. On the File menu, click Export, and then click Report Definition Language (.rdl).

  3. In the Export to Report Definition Language dialog box, under Output location, select one of the following options:

    • Publish to file
      In the File path box, type a path and file name or click Browse browse button to locate the path.

    • Publish to a SQL Server Reporting Services
      In the Server box, type the URL for the SRSS web service. The URL must include the server, the report server, and the name of the web service endpoint, for example: //localhost/reportserver/reportservice2005.asmx
      In the File path box, type a path and file name or click Browse browse button to locate the path.

  4. Under Export range, select one of the following options:

    • Current View
      Exports the current view of a report. If the current report view is three pages, Management Reporter exports all three pages.

    • Current Reporting Unit
      Exports the current reporting unit of a reporting tree. If the current reporting unit is three pages, Management Reporter exports three pages.

    • Selected Reporting Units
      Displays a dialog box for selecting the reporting units to export.

    • All Reporting Units
      Exports all reporting units in a reporting tree.

  5. Under Report type, select one or more of the following options:

    Note:  The Report Type options are not available if you select Current View for the Export range option.

    • Financial report
      Exports only the financial report.

    • Account details
      Exports only the account details report.

    • Transaction details
      Exports only the transaction details report.

    • Exception report
      Exports only the exception details report.

  6. If you want Management Reporter to replace files without warning, select the Replace files without warning check box.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×