4 Replies Latest reply on Mar 30, 2010 2:19 PM by Jigzat

    Sum portal data results after record search.

    Jigzat

      Title

      Sum portal data results after record search.

      Post

      Hello again everyone, I apologize for my first post, now I know I was asking too much but it was the result of the panic. I have a more straight question now.

       

      First I have in my database one table named "Holdings" and it has data from a related table named "persons" and "Departments" each registry has a mix between an owner and a renter that is taken from the Persons table and a department from the "Department" table.

       

      Second I have a table named "Dues" each registry represent a monthly fee and is linked to a "Holding". I want to create a layout that shows active (unpaid) "dues" discriminated by "holding".

       

      Since I don't wanted to create another table for that I created a layout based on the Holding table with a portal that displays data from the Dues table. The search part was easy, I created an script that performs a search of dues that doesn't have a pay date but the problem is I haven't figured out how to sum the result of the find script and only show active dues in the portal.

       

      Can someone please help me with that?

       

       

      This is the database http://files.me.com/jigzat/x78qch

       

      is in spanish by the way

       

      Tenencias = Holdings 

      Apartamentos = Departments 

      Cartera = Dues

      Personas = Persons