Suggestions to limit no. of displayed records in groups?

rbuser

Hi,

Anything similar to RangeEnd , RangeEndCount pair which will
limit the number of displayed rows inside a group? This
way one could have a report with groups, and inside a group I would
display, let's say the 10 top most ... (group by month, group by user,
show only 10 top most users)...

If not, any suggestions on how to accomplish this?

Regards,

Lucian

digitalmetaphors

The easiest waay would be to create a master detail report and use the
RangeEndCount. In SQL, there is no standard support to limit a number of
records for a group of data in the dataset.

If you don't have master detail data available, then you can use a report
variable component. When the group begins printing, set its value to zero.
Then, in its OnCalc event, increment its value. When the value reaches 10,
you know that this is the last detail band to be printed for the group and
you should be able to set the following detailband visiblities to False.
Then set it back to true when a new group begins.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hey, that's great: I'll try with a variable component.

Thx a bunch!

Lucian