You can also create an external report in any web pages (for example, ASP, ASPX, HTML, and JSP). This section shows an example of how to create an external report in an ASPX page and utilize the user parameters in a report URL string.
In the ASPX page, set up the connection to the database server using a connection string, such as the following:
SQL Server Database
<add name="SqlConnectionString" connectionString="user id=[kpreporteruser];password=[password];integrated security=false;data source=[servername];initial catalog=[databasename]" providerName="SQLOLEDB" />
Oracle Server Database
<add name="SqlConnectionString" connectionString="Data Source=[servername]/[databaseinstancename]; User Id=[kpreporteruser]; Password=[password];" providerName="System.Data.OracleClient" />
The ASPX page can also get the query string from the report URL, such as the UserID, WorkgroupID, and Custom User field names, and pass this information as parameters when running the database query script.