display sub report on last top 5 records 1

[fsreport]

Hi All
cr 9.0
ms sql
I have a main report thst has 1 group

and it only returns the top 5 records on the report

ex:
ph:
*** TOTAL LEGG MASON FUNDS / SMA
***Top 5 Territory
gr1: territory****sales****red***net
grft:INSURANCE****100******200***300
*****FUNDS********200******100****300
*****Assets*******300*******200***100
*****Bonds********200*******100***300
*****Cash*********100********200***300

that look fine but i need to insert a sub report to display right under the cash field in the gr ft
i tried inserting a section below and have underlay check and so result
it places my subreport on a new page insted of just below
here is what i would like to have on my report
ex:
Dealer is my subreport
***Top 5 Territory
gr1: territory****sales****red***net
grft:INSURANCE****100******200***300
*****FUNDS********200******100****300
*****Assets*******300*******200***100
*****Bonds********200*******100***300
*****Cash*********100********200***300
phDealer
gr1 Dealer
grft**abcd*********200*******200****400
******asrd*********100*******100****100
******ardf*********50********75******100
******sedr*********800*******100*****700

Thank you



fsreport

 

[Madawc]

I'd have thought you could put it in the Report Footer, maybe as one of several Report Footer sections.

If there's some reason you can't, then you could do a summary total and a running total, both counting by group. When these are equal, it is the last group. The basics of Crystal totals are explained at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[fsreport]

Hi Thanks for the replied.
I found the problem is beacuse my subreport has to much data on the first page so it does not fit in the remaining section of the first page of the main report.
Is there a way to have partial data showing on the first page of the main report?
let say i only have 30 records from the sub report showing on the first page of the main report and the rest on new pages after?
my sub report is group by firm_name and the the firm_
names and other calculation result are in the group footer

in other word i need about 30 records to show on the main report first page from the sub report and the rest on the other pages

fsreport

 

[Madawc]

Right-click on the subreport, choose Format Subreport. Probably [Keep Object Together] will be checked, and can be unchecked.

If you wanted exactly 30 lines, you can do a selective [New Page After] for any section, including detail lines in a subreport.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10