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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using MoveLayout to print subtotal on last detail line of group 2
Calculate percent for values in detail section 2
Suppress a section if the subtotals equals zero 1
Custom function in detail section 2
Columns in sub-report on detail section 1
Using "Sum" to add values from records in detail section 8
Control detail section height size in Ac2007 2
Excel Subtracting multiple columns from another column 3

Back
Top