- Create an External Report
- Create an External Report
- "ed89cddf-8736-4b87-90b7-cb14ccc9cb73
- When you create an external report, you use an external tool to connect to the database server and retrieve the data. To make this connection, there are two options: 1) Windows authentication or 2) Oracle or SQL server authentication. Which one you use will depend on how the server was set up by the database administrator. Contact your database administrator for this information that you will need to construct the report:
- The name of the Oracle or SQL server.
- A login to access the Oracle or SQL server. The user name should have the KPREPORT role assigned to it. This role allows the login to access the database, but restricts that access to retrieving data.
- The password for the login.
- You can use any of the tables and views in the database for the report, as listed in the next section. Once the report is complete, save it in a format that can be viewed in a Web browser and copy it to a Web server. The next step is to add it as an External Report in Reports. See
- External Report Properties