AnsweredAssumed Answered

Script to display certain data

Question asked by mayor on Jun 15, 2009
Latest reply on Jun 21, 2009 by 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

Outcomes