> For the complete documentation index, see [llms.txt](https://documentation.2pintsoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://documentation.2pintsoftware.com/ipxe-ws/4.0/installation/install-ipxe-anywhere-reports.md).

# Install iPXE Anywhere Reports

## **Prerequisite**

The reports require an installation of Microsoft SQL Server Reporting Services.

## Download the reports

The reports and the script used to import them are not included with the iPXE Anywhere Web Service installer. Download them from the [Reports/SRSS 2014 Reports](https://github.com/2pintsoftware/2Pint-iPXEAnywhere/tree/main/Reports/SRSS%202014%20Reports) folder in the 2Pint GitHub repository:

* **IPA\_One\_Hour\_Summary.rdl**, **IPA\_Main\_Dashboard.rdl** and **IPA\_Hardware.rdl**: the reports (see [The iPXE Anywhere reports](/ipxe-ws/4.0/configuration/integrating-with-2pxe-server.md#the-ipxe-anywhere-reports) for a description of each report).
* **Import-2PSReports.ps1**: the PowerShell script that imports the reports into SSRS.

Save all of the files in the same folder.

## Installation

### Create an iPXE Anywhere DataSource

It is necessary to create a Data Source in order for the reports to connect to the correct Database and tables within the reports.

1. Start Report Manager (SSRS Native Mode).
2. In Report Manager, navigate to the Contents page.
3. Click New Data Source. The New Data Source page opens.
4. Type a name for the item. A name must contain at least one character and it must start with a letter. It can also include certain symbols, but not spaces or the characters ; ? : @ & = + , $ / \* < > | " /.
5. Optionally type a description to provide users with information about the connection. This description will appear on the Contents page in Report Manager.
6. In the Data source type list, specify the data processing extension that is used to process data from the data source.
7. For Connection string, specify the connection string that the report server uses to connect to the data source. It is recommended that you do not specify credentials in the connection string.

   The following example shows a connection string for connecting to the iPXE Anywhere database:

   ```
   data source=<SQLservername>; initial catalog=iPXEAnywhere
   ```
8. For **Connect using**, specify how credentials are obtained when the report runs:

* If you want to prompt the user for a logon name and password, click Credentials supplied by the user running the report. To use the credentials that the user enters as Windows credentials, click Use as Windows credentials when connecting to the data source. If the user name and password are database credentials, do not select this option.
* If you intend to use the data source as a shared data source with saved credentials that are managed by the owner of the data source, or for reports that support subscriptions or other scheduled operations (such as automated report history generation), click Credentials stored securely in the report server.
* If the database server supports impersonation or delegation, you can select Impersonate the authenticated user after a connection has been made to the data source.
* If you want the report server to pass the credentials of the user accessing the report to the server hosting the external data source, click Windows Integrated Security. In this case, the user is not prompted to type a user name or password.

### **Installing the Reports**

Once the data source is created in the step above, import the SSRS reports using the **Import-2PSReports.ps1** script that you downloaded. The only required argument is the name of the SSRS report server where the reports are to be imported and where the data source resides. By default, the script imports all of the .rdl files in the current folder; use the `-SourcePath` parameter to import them from another folder.

Example, run from the folder that contains the downloaded files: `.\Import-2PSReports.ps1 -ReportServer MYSERVER`


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://documentation.2pintsoftware.com/ipxe-ws/4.0/installation/install-ipxe-anywhere-reports.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
