Data Sources

Report data is used in two ways: whenever subject or metric formula are needed, or any time in report definition you can use { } to specify a full formula. See Formula section.

Report data can be specified as either as moxydoc:dataSource or as moxydoc:data

DataSource

the dataSource pulls data from the data base.

Attributes

id

a unique ID that allows the form to be referenced by the application and by the report.

source

specifies the name of the data base table.

select

select a column from the data base table.

for

Example

<moxydoc:reportData>    

   <moxydoc:dataSource id="Sessions" source="SESSIONS" />

   <moxydoc:dataSource id="Case" source="CASE" />

   <moxydoc:dataSource id="Orgs" source="ORGS" />

 </moxydoc:reportData>

Data

Data be added to a report. This is useful for testing purposes.

Attributes

subjectCode

defines the code to specify the subject data.

date

the data must have a date.

other user defined attributes can be added, and will be treated as metrics

Example

<moxydoc:reportData>    

   <data subjectCode="TXT.JAZ" ACTUAL="11" date="30 June 2010" />

   <data subjectCode="TXT.SNA" ACTUAL="420" date="30 June 2010" />

</moxydoc:reportData>


Click to see Comments

Help comments powered by Disqus

In this section