TopN Groups

[draganss]

I'm using CR biult in VS.NET 2002.
SQL 2000

My report is grouped.
I need to show only TopN (10,15,20....)groups based on column SubTotal of the group.

Thank you,
Marin

 

[lbass]

And your question is?

Go to report->group sort->topN->based on: your subtotal.

-LB

 

[draganss]

Thank you LB.
I don't know how I missed such obvious option.

Is it possible to change N in runtime, through VB code?

Marin

 

[draganss]

Yes, it is possible.

Within the report I've predefined TopNSorting(as LB suggested).

Within the code I’ve created simple Sub

Public Sub SpecSta2(ByVal N As Integer, ByVal iTopN As Integer)
Dim topBottomNSortField As TopBottomNSortField
If TypeOf oRpt.DataDefinition.SortFields.Item(iTopN) Is TopBottomNSortField Then
topBottomNSortField = oRpt.DataDefinition.SortFields.Item(iTopN)
topBottomNSortField.NumberOfTopOrBottomNGroups = N
End If
End Sub

where oRpt is ReportDocument
iTopN is index of the SortField