PaquettePaul
Member
- Local time
- Today, 09:54
- Joined
- Mar 28, 2022
- Messages
- 107
I have a report based on a query which provides financial activity for a person. In the query, the data is sorted by student, effective date, and financial type. When I look at the results of the query, the student and date information are correct as well as the financial activity - goods and services (type 21) is followed by goods and services tax (type 22) which is followed by a debit payment (type 30). However, in the report, the debit payment is listed before the other two entries. Note that internally, the primary key of the records is payments before charges.
Not much sense showing you any code as the query is correct and there is nothing in the code to change the sort. The only processing that occurs is the data is filtered for a specific student as part of the report filter criteria.
Any suggestions to resolve this inconsistency?
Not much sense showing you any code as the query is correct and there is nothing in the code to change the sort. The only processing that occurs is the data is filtered for a specific student as part of the report filter criteria.
Any suggestions to resolve this inconsistency?