BI Publisher - How to bring data from 2 select into one report

Feb 19, 2015 9:37AM

I'm trying to bring total at the end of the report for the number of checks and the total dollar amount. Can someone help with this.

<?xml version="1.0" encoding="UTF-8"?>

<RWJF_ACH_INVOICE>

<P_BATCH_NAME>Test Sury 2-18-15 1</P_BATCH_NAME>

<LIST_G_INVOICE_REVIEW>

<G_INVOICE_REVIEW>

<CHECKRUN_NAME>Test Sury 2-18-15 1</CHECKRUN_NAME>

<VENDOR_NAME>GirlTrek Incorporated</VENDOR_NAME>

<VENDOR_SITE_CODE>72480</VENDOR_SITE_CODE>

<ADDRESS_LINE1>P.O. Box 53175</ADDRESS_LINE1>

<ADDRESS_LINE2/>

<CITY>Washington</CITY>

<INVOICE_NUM>Sury18-FEB-2015</INVOICE_NUM>

<INVOICE_DATE>2015-02-18T00:00:00.000-05:00</INVOICE_DATE>

<INVOICE_AMOUNT>2</INVOICE_AMOUNT>

BI Publisher (MOSC)