limit # of records in subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to limit the number of records displayed in a subreport to 10. I can't
use a Top n predicate on the query.

How can I achieve this?

Thanks in advance for the help. I may have posted this question before. I
apologize if this is indeed a double post.
 
You can set the subreport size to display 10 records and not allow it to
grow. You may want to allow it to shrink.
 
I should clarify:

The query behind this subreport pulls transactions for all members in a
group. A report is generated for every member in the group with the
'transaction' subreport. I can only allow one page per member and 10
transactions are the max that will fit on one page.
 
I'm not sure what this latest information has to do with setting the maximum
size of the subreport?
 
Thanks Duane. I love simple solutions and hate it when I don't think of them.
I tried everything but setting the size of the subreport.
 
Back
Top