<?xml version="1.0"?>

<report name="items-barcode" pdf-renderer="items-barcode.xsl">
	<title>Kassenbericht</title>

	<report-parameter name="TENANT" type="integer" hidden="true">
		<preset>@TENANT_NO</preset>
	</report-parameter>
	<report-parameter name="COMPANY" type="integer" hidden="true">
		<preset>@COMPANY_NO</preset>
	</report-parameter>
	<report-parameter name="DEPARTMENT" type="integer" hidden="true">
		<preset>@DEPARTMENT_NO</preset>
	</report-parameter>

	<report-result report-dataset="items">
	</report-result>


	<report-dataset name="items">
		<sql>
			select * from items where tenant_no=@TENANT_NO and company_no=@COMPANY_NO and department_no=@DEPARTMENT_NO and ((not item_ean is null) or (not item_ean2 is null)) order by coalesce (stockable, 0), item_cd
		</sql>
	</report-dataset>

</report>
