haap

Thanks for the reply Tyson. What would be the query to create a custom report with the same fields as the transactions received report plus the services purchased by each client and two custom fields I have created (Client Additional Email and Client DOB)?

Hello! I am new to Blesta and I am having some trouble adding information to the existing "Transactions Received" report. I have created 4 "Custom Client Fields" and would like to include them into this report. What must I add to the "$this->Record->select($fields, false)" and "$fields = array("transactions.*", section of the transactions_received.php file in order to pull the information from the custom fields in the database? Aside from adding the "custom client fields" to my report I would also like to include a colum with the services the client has purchased. Any help with this would be very much appreciated. Please let me know if I need to provide more information about the custom fields created.