Step by Step Jasper Report for Print format WINDOW Adempiere

Hmm… where do i start ??
let’s start from your jaspereport file, e.g a.jrxml may look like this :

<parameter name="RECORD_ID" isForPrompting="true"
class="java.lang.Integer">
<defaultValueExpression>new Integer(0)</

defaultValueExpression>
</parameter>
<queryString>
select
org.name as ORGANISATION,
b.name as BUSINESSPARTNER,
l.qtyEntered as QTYENTERED,
c.name as UOMSYMBOL,
p.name as PRODUCTNAME,
asi.description as ASI,
l.priceEntered as PRICEENTERED,
l.linenetamt as LINENETAMT
from
c_orderline l
inner join c_uom c on c.c_uom_id = l.c_uom_id
left outer join m_product p on l.m_product_id = p.m_product_id
left outer join m_attributesetinstance asi on
l.m_attributesetinstance_id = asi.m_attributesetinstance_id
inner join c_order o on o.c_order_id = l.c_order_id
inner join ad_org org on org.ad_org_id = o.ad_org_id
inner join c_bpartner b on b.c_bpartner_id = o.c_bpartner_id
where
l.c_order_id = $P{RECORD_ID}
</queryString>

please notice i’m using RECORD_ID parameter name.

2 create the report and process in adempiere (i guess you should have this knowledge). Please notice you does not need create any parameter

3. go to window and tab in adempiere, select the header tab, look for process field, then choose your report and process.

4. it’s done…. the print format will come out and the jasper report will give u a record base on the record that u choose in adempiere window

Advertisement