I need to create a SSRS report allowing the user to list all withdrawals from the checkbook, only checks and then only direct deposit transactions. In other words they want to be able to list the payroll direct deposit entries separately on the checkbook register report. Can anyone tell me the table relationships that will allow this? The CM20200 and DD30101 I am sure must be involved. Can it be done with just these two tables or are there other tables involved?
*This post is locked for comments