How to pull all subreport data when no link to main

[BLKDAWG]

CR9/Peoplesoft. My main report oulls FY budgets by chartfield string (fund/program/deptid/account). Information is pulled from a Peoplesoft query.

I've created a subreport to pull all transactions that have hit a particular buget. Transactions are pulled from a union of about 12 records in Peoplesoft query. The subreport is linked to the main report by chartfield string.

I have a few cases where this is no budget for a particular chartfield string, but there are transactions. Apparently these transactions were overridden and show as negatives against a non-existence budget. Since there is no budget to tie to these transactions, they are not showing in my report.

I tried making the Transactions my main report and the budget my subreport, but I run into the same issue. Some budgets have yet to have transactions, so the budgets don't tie to anything in the main report therefore they don't show up in the report.

Does anyone have either a way to work around this, or maybe a better design approach I should use for this report?

 

[lbass]

One approach would be to use a third table for your main report that has all accounts. Then add the budget and the transaction tables in separate subreports placed in group sections of the main report, and linked to that group field.

-LB