# Install iPXE Anywhere Reports

## **Pre-Requisite**

The reports require an installation of Microsoft SSRS.

## 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 illustrates a connection string for connecting to the local SQL Server iPXE Anywhere database:

data source=\<SQLservername>; initial catalog=ipxeanywhereDB

1. 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 PowerShell Script that is included with the iPXE Anywhere Files, named Import-2PSReports.PS1. The only required argument for this is the name of the SSRS Reporting Server where the files are to be imported and the Data Source resides.

Example: .\Import-2PSReports.ps1 –ReportServer MYSERVER


---

# Agent Instructions: Querying This Documentation

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

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

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

The question should be specific, self-contained, and written in natural language.
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.