By using this website, you agree to our Terms of Use (click here)
I am attempting to make a report that outlines some statistics of our office. Ideally it would show the count of Journal Entries and Purchase Orders, as well as Accounts Payable transactions and Accounts Receivable transaction both categorized by document type. I'm not sure if this is possible since all of these data tables may not relate together, but I was wondering if there was a way to work around the relations.
If anyone has any knowledge on this that would be very helpful!
Here's a better visual of what I am going for
Purchasing:
Purchase Orders: #,###
Accounts Payable:
Bills: #,###
Debit Memos: #,###
Credit Memos: #,###
Total: #,###
Etc.
If you can't figure out the joins, you can always use subreports to get non-joined data.
I agree with Ellie, Subreports are the way to go for this. Do a separate Subreport for each KPI, then do a Main report that pulls all of the Subreports together.
By the way, this is the kind of thing that Power BI is good at because it can do the joins between different kinds of data sets using a Star schema composed of Dimension and Fact tables.