2 Replies Latest reply on Jun 21, 2009 11:18 PM by mayor

    Script to display certain data



      Script to display certain data




      I facing a problem how to generate the report for certain data.

      I got 2 tables, research and expenses


      Research ( research_account_no, researcher_name, amount, status ....)

      Expenses (research_account_no, invoice_no, invoice_date ....)


      Relational field : research_account_no


      I intend to generate report in 1 layout as below. When I click 1 button,

      data as below will be displaed, just only display data where the status is "active".



      Research Account No           Amaunt          Status

      ---------------------            --------          -------

      AQ123                               $10000         active

      RD356                               $25000         active


      and so on...


      So, how to do that.