I want to use Koolreport to write reports on an existing Laravel application. I would like to use the Models to grab the data instead of directly using sql bc the models have business logic that I do not want to repeat.

Using the laravel package for koolReport i can get basic reports working. My problem comes when i have a model that has relationships and I want to report on any of the child data. For example, I have a class called Customer. Customer has a relationships with Payments. I would like to sum the payments in a report. I have tried several ways to refer to the sum of the payments but i have not been able to get anything to work. Is there an example of how this would work?

thank u.