Forums
Lawson Business Intelligence/Reporting/Crystal
Need GLTRANS and FBDETAIL view
Author
Messages
Donna
Veteran Member
Posts: 110
11/16/2016 3:30 AM
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