Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
nameblue

Report Pages Documentation

Report pages are used to display information in the system through SQL statements and criteria defined either in a single criteria file (.crxml) or both a criteria file in combination with a layout file (.jrxml). Note that in order to use the two files together, they must have the same name.

Child pages (Children Display)

Example

Expand
titleReport Page

Image Added 

Code Block
themeEclipse
languagexml
title.crxml
<config>
    <name>PaymentsByUser</name>
    <description>Payments By Users</description>
    <defaultgroupby></defaultgroupby>
    <dataset></dataset>
    <sqlansi>
    SELECT p.PAYMENTID,
           p.PAYMENTNUM,
           p.PAYMENTAMT,
           p.PAYMENTCREATEDBYUSERID,
           p.PAYMENTCREATEDDATE,
           p.PAYMENTAMT,
           users.USERNAME,
           pm.PAYMETHODNAME,
           v.VOUCHERNUM,
           v.VOUCHEREXPIRATIONDATE,
           s.SUBNUM
    FROM PAYMENTS p
    INNER JOIN USERS ON USERS.USERID = p.PAYMENTCREATEDBYUSERID AND USERS.USERDELETED = 0
    INNER JOIN PAYMENTMETHODS pm ON pm.PAYMETHODID = p.PAYMETHODID AND pm.PAYMETHODDELETED = 0
    INNER JOIN VOUCHERS v on v.VOUCHERID = p.VOUCHERID AND v.VOUCHERDELETED = 0
    INNER JOIN ACCOUNTSRECEIVABLE acr on acr.ACCRECID = p.ACCRECID AND acr.ACCRECDELETED = 0
    INNER JOIN SUBSCRIPTIONS s on s.ACCRECID = acr.ACCRECID AND s.SUBDELETED = 0
    ORDER BY p.PAYMENTCREATEDDATE,
         users.USERNAME,
         p.PAYMENTCREATEDBYUSERID,
         p.PAYMETHODID
    </sqlansi>
    <copysqltosubreports>true</copysqltosubreports>
    <hql></hql>
    <criterialist>
        <criteria>
            <ordernum>1</ordernum>
            <criteriatype>0</criteriatype>
            <label>User Name</label>
            <entitytablename>users</entitytablename>
            <entityfieldname>USERNAME</entityfieldname>
            <fieldtype>ftXString</fieldtype>
            <fieldsize>32</fieldsize>
            <displaytable>USERS</displaytable>
            <displaylabel>Person Name</displaylabel>
            <displayfield>UserPersonName</displayfield>
            <sourcealias>UserName</sourcealias>
            <displayalias>UserPersonName</displayalias>
            <datasetname>users.load</datasetname>
        </criteria>
        <criteria>
            <ordernum>2</ordernum>
            <criteriatype>0</criteriatype>
            <label>Creation Date</label>
            <entitytablename>p</entitytablename>
            <entityfieldname>PAYMENTCREATEDDATE</entityfieldname>
            <fieldtype>ftXdatetime</fieldtype>
            <fieldsize>32</fieldsize>
        </criteria>
        <criteria>
            <ordernum>3</ordernum>
            <criteriatype>0</criteriatype>
            <label>Payment Method</label>
            <extralabel>Payment Method</extralabel>
            <tooltip></tooltip>
            <hibernatefield></hibernatefield>
            <entitytablename>p</entitytablename>
            <entityfieldname>paymethodid</entityfieldname>
            <displaytable>Payments</displaytable>
            <displaylabel></displaylabel>
            <displayfield>paymethodname</displayfield>
            <fieldtype>ftXString</fieldtype>
            <fieldsize>32</fieldsize>
            <sourcealias>paymethodid</sourcealias>
            <displayalias>paymethodname</displayalias>
            <datasetname>financialtransactions.loadpaymentmethods</datasetname>
            <treename></treename>
            <multiselect>1</multiselect>
        </criteria>
    </criterialist>
</config> 

.jrxmlImage Added