J
jpo
Is it possible to limit the number of times a subreport executes perhaps
using VB?
My problem is this:
I've inherited/edited a database that lists a summary of plans, and the
details for the last 10 transactions in a report. The user has the option to
run the report for an individual, or for all individuals in a group. The main
report is based off a query that selects active members and there are
subreports for plan summary and transactions. I use the SELECT TOP 10 to
limit the number of transactons when querying for an individual. This doesn't
work when querying for an entire group. So my thought is to somehow limit the
number of times the subreport runs (10), so that even when there are more
than 10 transactions for an individual in my "group transaction" query, it
will only show ten in the report.
Thanks in advance.
using VB?
My problem is this:
I've inherited/edited a database that lists a summary of plans, and the
details for the last 10 transactions in a report. The user has the option to
run the report for an individual, or for all individuals in a group. The main
report is based off a query that selects active members and there are
subreports for plan summary and transactions. I use the SELECT TOP 10 to
limit the number of transactons when querying for an individual. This doesn't
work when querying for an entire group. So my thought is to somehow limit the
number of times the subreport runs (10), so that even when there are more
than 10 transactions for an individual in my "group transaction" query, it
will only show ten in the report.
Thanks in advance.