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

    Script to display certain data

    mayor

      Title

      Script to display certain data

      Post

      Hello,

       

      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.

       

      TQ