Skip to main content

Portable database reporting using Java and XML

How to generate printable reports with Java, XML, and FOP

Return to the article


MXReports.DTD
<!-- Root element for report definition.-->

<!ELEMENT Report (Page,SQLSatement)>

<!ATTLIST Report
 Name ID #REQUIRED
 Title CDATA #REQUIRED
 Version CDATA #FIXED "1.0"
>

<!ELEMENT Page (ReportBand+)>

<!ATTLIST Page
 Height CDATA #REQUIRED
 Width CDATA #IMPLIED
>

<!-- SQL connection used for retrieving data from the database-->

<!ELEMENT SQLSatement EMPTY>

<!ATTLIST SQLSatement
 Name ID #REQUIRED
 Username CDATA #REQUIRED
 Password CDATA #REQUIRED
 Statement CDATA #REQUIRED
 Driver CDATA #REQUIRED
 URL CDATA #REQUIRED
>

<!ELEMENT ReportBand (ReportElement+)>

<!ATTLIST ReportBand
 Name ID #REQUIRED
 Height CDATA #REQUIRED
 BandType (HeaderBand | FooterBand | DetailBand) #REQUIRED
>

<!ELEMENT ReportElement (Label|DataField)>

<!ATTLIST ReportElement
 Name ID #REQUIRED
 Height CDATA #REQUIRED
 Width CDATA #REQUIRED
 Left CDATA #REQUIRED
 Top CDATA #REQUIRED
 ElementType (Label | DataField) #REQUIRED
>

<!ELEMENT Label (Font)>

<!ATTLIST Label
 Data CDATA #IMPLIED
>

<!ELEMENT DataField (Font)>

<!ATTLIST DataField
 SQLStatement IDREFS #REQUIRED
 FieldName CDATA #REQUIRED
>

<!ELEMENT Font EMPTY>

<!ATTLIST Font
 FontName (Arial | Courier | Times | SansSerif) #REQUIRED
 Style (Regular | Bold | Italics | Underlined) #REQUIRED
>