AnsweredAssumed Answered

Script to display certain data

Question asked by mayor on Jun 15, 2009
Latest reply on Jun 21, 2009 by mayor


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.