PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/15/2016 10:30 PM by  Donna
Need GLTRANS and FBDETAIL view
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Donna
Private
Private
Veteran Member
(259 points)
Veteran Member
Posts:107


Send Message:

--
11/15/2016 10:30 PM
    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
    You are not authorized to post a reply.