XML Report using Data template
I am using following code as a .xml file.
<?xml version="1.0" encoding="WINDOWS-1252" ?>
<dataTemplate name="CSTPD " description="Products Demo " version="1.0">
<parameters>
</parameters>
<dataQuery>
<sqlStatement name="Q_Invoice">
<![CDATA[
select ai.Invoice_id invoice_id
,ai.Invoice_amount invoice_amount
,ai.vendor_id vendor_id
,ai.amount_paid amount_paid
,ai.invoice_date invoice_date
,ail.line_number line_number
,aid.distribution_line_number distribution_line_number