Here is the command that I am trying to edit. I have never done a report with a command and I am not sure on exactly how to edit it. But here is the code:
SELECT
'B' TX_TYPE, VENDOR_ID, BILL_NUMBER, TX_DATE, ROUND(TX_AMT, 2) TX_AMT,
CURRENCY_CODE, TX_POSTED, AP_BILL_ID ID,
(
SELECT...