How to build a Quick Report in SalesPad

http://docs.salespad.net/support/desktop-support/entry/reporting/quick-reports-reference-guide



<?xml version="1.0" encoding="utf-16"?>
<report name="Recent Sales Documents" AutoLinks="true" GroupFooterShowMode="Expanded">
  <search name="Sales Person" column="Sales_Person_ID" searchOp="like" />
  <search name="Doc Date" Type="DateTime" column="Doc_Date" searchOp="&gt;=" />
  <query addWhere="true">

<![CDATA[ select * from spv3SalesDocument ]]>

</query>

  <column name="Sales_Person_ID" BestFit="true" />
  <column name="Doc_Date" Sort="Descending" />
  <OnRunScript>
  </OnRunScript>
</report>

report
name
autolinks TRUE FALSE
GroupFooterShowMode Expanded
bestFitAll TRUE FALSE
autoRun TRUE FALSE
 HideUndeclaredColumns TRUE FALSE
query
addwhere TRUE FALSE
search
name “Sales Person”
column “Sales_Person_ID”
searchOp like &gt;= &lt;=
Type DateTime lookup
sql Lookup sql=”SELECT DISTINCT xManufacture FROM spxItemMaster where xManufacture IS NOT NULL”
column
name
BestFit TRUE FALSE
DisplayFormat $#,##0.00###
SummaryType Sum Count Average
Caption “Job Supplies”
Visible TRUE FALSE
sort descending ascending
OnRunScript