to show 30 records in detail section

  • Thread starter Thread starter sapta
  • Start date Start date
S

sapta

need your help,
i have a report that have group footer for sub total,
it results 4 sub total item (A,B,C,D), which have
different number of records ie. 20, 40 , etc.I Details.
how to set in order to every subtotal(A,B,C,D) only show
ex. 20 records or row,without changing the SQL statements.

thanks in advance
 
I think what you want is to show only a few records within
each group (A, B, C, or D) One way to do that is to
create a report and a subreport. In the main report
create a grouping for whatever the A-B-C-D field is.
insert the subreport in the group footer and link to the
grouped field.
now set the size for the subreport and do not allow to
grow.
You may have to play with the sizing.
Good Luck
Fons
 
Back
Top