Get the first record from sub-report to main report

[maas]

Dear All,

I am having a problem:

I have a main report which has
deal_no, amount, deal_date

In the sub-report: I am getting the Deal_number, maturity_date, effective_date ...etc. I kept the sub-report to prompt the user to enter any date and regarding the entered date, all the marurity dates will be listed and amounts.

Now, when I run the report, it lists me all the maturity dates, effective dates ..... etc.

So, how can I get only the first record and ignore the others (first line) and retrieve them to the main report?

Thanks

 

[fisheromacse]

to display only the first record, sort the data by the desired criteria, then put the fields in the header instead of the details section