0

I needed code for dynamically selecting the TopN/Sort Group Expert in crystal report. I am using VB.net and SQL. My report has its data coming from a stored procedure written.
This will be of great help as i needed to give the option for my top sales report.

2
Contributors
1
Reply
2
Views
10 Years
Discussion Span
Last Post by GrandVizier
0

I've got the same problem here. I've been looking into doing the same thing and haven't found any solutuions. I've got 3 different fields that I want the user to be able to sort by. I also would like them to have the option of entering a parameter to limit the results displayed. Of course this can all be easily done during design time with 'TopN/Sort Group Expert', but how do you sort a Sum field during runtime.

I've tried using sort fields but I can't get beyond an "Invalid field name" error.

Dim crSortField As SortField
        Dim fieldDef As DatabaseFieldDefinition
        For Each crSortField In crReportDocument.DataDefinition.SortFields
            If crSortField.Field.Name.ToString = strField Then
                fieldDef = crReportDocument.Database.Tables(0).Fields(crSortField.Field.Name.ToString) 'where error occurs 
                crSortField = crReportDocument.DataDefinition.SortFields(0)
                crSortField.Field = fieldDef
                crSortField.SortDirection = SortDirection.DescendingOrder
            Else
               'used for debuging
                Label1.Text += " " & crSortField.Field.Name.ToString & ", " 
            End If
        Next
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.