Available sample reports
Populate a sample report with your own data
Each sample report contains information obtained by processing a set of sample documents. Replace that data with your own.1
Install and configure the Reporting Service
For more information, see System requirements and installation.
2
Process some documents
The service collects the processing data that the report draws on.
3
Open the report in Microsoft Excel
Open the file that contains the report you need.
4
Open the data model
Click Data on the menu bar, and then select Manage Data Model.
5
Edit the existing connection
On the Get External Data drop-down menu, click Existing Connections. In the Existing Connections dialog box, find the PowerPivot Data Connections section, select
fc_stat, and then click Edit.6
Build the connection to the Reporting Database
In the Edit Connection dialog box, click Build, and then enter the connection information:
- On the Provider tab, select SQL Server native Client.
- Select the appropriate SQL server and database.
- Test the connection and save the changes.
7
Refresh the report
In the Existing Connections dialog box, click Refresh. To refresh all the data in the report, click Data on the menu bar, and then click Refresh All.
