I building a Request report and I want to be able to break out the individual payments on my Request. How can I go about doing this so my report displays payments that occur over several years?
One means to display multi-year payments is to insert the Total Payment Amount column in your report.
1. Within the Report Designer, go to Options > Columns 2. Once the Columns are open, choose 'Request' from 'Select available columns from' dropdown 3. Highlight 'Total Payment Amount' and click 'Include>' to bring it into the report 4. Once the column is listed on the right-hand side, highlight it once more and click the 'Formatting' button below 5. In the resulting window, click the 'Modify' link under Filters and adjust your filters using Date Paid or Schedule Date filters accordingly
Keep in mind that you can add as many Total Payment Amount columns as you like.