How to get the first recordonly in the subreport to the 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 put the sub-report to prompt the user to enter any date any 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 other and retrieve them to the main report.

Thanks

 

[IanWaterman]

In subreport sort data as required, group by deal number suppress details and move all the fields from details into group header.

Ian

 

[lbass]

Please do not create multiple posts on the same topic.

-LB