Report

[BorisGomel]

Hello to all of you,

I am just wondering if it is possible to have different sources attached to on one report. For examples, I have report called Chase ETF and its control source comes from query called Chase total. The report is showing gross, commission, net – all are divided by four categories -gross remit, direct payment, nsf and voids. Everything is working fine, but I was asked to put in report invoices from Oracle that makes easy to reconcile invoices to payables from the bank. I created another table and started append it every day entering invoices for remit, direct payment and so on – it is one invoice for each category. I created a query called Oracle Invoices and now I am stuck -I would like put oracle invoices on report that match day of invoicing accordingly subcategory-remit, nsf and so on form query Oracle Invoices.

Thank you in advance for help,


Best Regards,

BorisGomel

[aytee111]

You cannot have more than one record source. However, you could create multiple subreports, each with their own record source, and place them in the report where you require them.