Creating an XML file for custom reports

To create an XML file for custom reports:

1. Start and end the file with a <METADATA> and </METADATA> tag.
2. For each custom report you want to load, create one REPORT tag. This tag has the following syntax:

   <REPORT
   [UUID="id"]
   ASPFILENAME="name"
   ASPTEXT="code"
   QUERYFILENAME="name"
   QUERYTEXT="text"
   [SETUPFILENAME="name"]
   [SETUPFILETEXT="name"]
   [TITLE="name"]
   [DESCRIPTION="text"]
   [REPORTTYPE="ADMIN|NORMAL"]
   [DATASOURCENAME="text"]
   [DATASOURCEUSER="text"]
   [DATASOURCEPASSWORD="text"]
   [LANGUAGE="name"]/>

3. Assign the following values to the REPORT tag attributes:

   Attribute	Value
   UUID	Leave blank. A blank UUID indicates that the definition is for a custom report.
   ASPFILENAME or ASPTEXT	Name of the ASP file defining the report, or the actual ASP text. One of these is required.
   QUERYFILENAME or QUERYTEXT	Name of an SQL file defining the patient data retrieval needed for the report, or the actual SQL statements. Optional. These attributes are for documentation only.
   SETUPFILENAME or SETUPFILETEXT	Name of an SQL file defining report-specific tables, views, indexes, and stored procedures that are necessary to create the report, or the actual SQL statements. Optional. If specified, use one or the other of these attributes.
   TITLE	Title of the report. This appears as a selectable link on the Custom tab and in the title bar of the report when it is generated online.
   DESCRIPTION	Description of the report, for documentation only.
   REPORTTYPE	Blank or NORMAL.
   DATASOURCENAME, DATASOURCEUSER, DATASOURCEPASSWORD	Name, user name, and password of the ODBC data source used to access report data, if you are using a database other than the InForm application database—for example, a CDD.
   LANGUAGE	Language used to display the caption. Optional. English is the default.

• Access to Oracle Support
• Accessibility
• Legal Notices

Copyright © 1998, 2015 Oracle and/or its affiliates. All rights reserved.