Really no idea what I'm doing with reports
I'm trying to understand the data behind reports
For example lets say I want to have a report that shows all of the transactions for a month, and then also a breakdown of money spent by category (see example below)
before I even get to how to lay this out in the report. will I need a query for payments in the date range, and query for deposits for that date range, and query for totals by category for that date range?
Or can I actually pull all of that data directly to the report from the transactions table?
just trying to understand the bigger picture of how reports work, Thanks
REPORT TITLE
Payments-
food for meeting - $350
Loan to chpt1 - $1000
Loan to chpt9 - $1000
Venue fee for mtg - $125
Total - $2475
Received
Chapter 1 Dues - $975
Chapter 2 Dues -$850
Chapter 2 Fine -$200
Total -$2025
Totals By Category
Loans -$2000
Meeting cost -$475
Dues -$1825
Fines -$200