limit # of records in subreport

J

jpo

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.
 
D

Duane Hookom

You can set the subreport size to display 10 records and not allow it to
grow. You may want to allow it to shrink.
 
J

jpo

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.
 
D

Duane Hookom

I'm not sure what this latest information has to do with setting the maximum
size of the subreport?
 
J

jpo

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.
 
Top