Create a calculated field on the dataset which has these records summarized. You could place this calc field in a lookup query so that you can use the values in the summaryband's variable calculation. Since there is a separate query to get these calc fields, you can easily exclude these records in the main query for the report, so that the detail bands are never generated for them.
Comments
You could place this calc field in a lookup query so that you can use the
values in the summaryband's variable calculation. Since there is a separate
query to get these calc fields, you can easily exclude these records in the
main query for the report, so that the detail bands are never generated for
them.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com