Need GLTRANS and FBDETAIL view

I am preparing a crystal report that uses GLTRANS for the expense column and provides totals by system code that tie back to all the sub systems.

The report also displays budget in a sub report at the account level but the report performance is terrible. There is a significant percentage of accounts that do not have expense transactions but are budgeted.

Does anyone have a view or sql query that might be helpful in obtaining all the populated records for each table? The view does not need the calculations but just the fields from the 2 tables and perhaps any intermediate table that may facilitate the join. I am currently using GLMASTER for the rollup and believe that if I can eliminate the sub report, report performance will improve and null records for both tables will be easier to control.

Thank you.
Donna