I am working on a business process for credit card usage reports. I have a collection that allows you to split the transaction across GL codes. After the process is complete, we would like to use a custom report to see all the submissions and splits easily. Unfortunately, I don’t see an option to add collection values to a report.

My next idea was to create hidden fields that would populate with the GST, GL code, and total for each row/ split in the collection. These fields could be added to the report. I can’t figure out the syntax to select the field from a specific row though.