Codejock Developer Community : FilterText question

FilterText question : OK. Now I understand all....This...

Thu, 01 May 2008 17:27:44 +0000

Author: msotocl
Subject: 10180
Posted: 01 May 2008 at 5:27pm

OK.

Now I understand all....This one very good

Thank you very much

FilterText question : Hi, What doesn't work?...

Thu, 01 May 2008 00:25:38 +0000

Author: Aaron
Subject: 10180
Posted: 01 May 2008 at 12:25am

Hi,

What doesn't work?

Right clicking a column will select the column and enter your sort text. The * will replace all chars beginning with "Data..."

FilterText question : HiThank you for your help... but...

Wed, 30 Apr 2008 17:03:35 +0000

Author: msotocl
Subject: 10180
Posted: 30 April 2008 at 5:03pm

Hi

Thank you for your help... but the sample not work...

FilterText question : Hi, This is a sample project...

Tue, 29 Apr 2008 05:54:41 +0000

Author: Aaron
Subject: 10180
Posted: 29 April 2008 at 5:54am

Hi,

This is a sample project how to sort on a certain column. The ReportControl is V11.1 (I don't have an earlier version). Just replace the ReportControl with your own version if necessary.

uploads/20080429_153244_TestSorting.zip

FilterText question : Hi. i not undestand your example... please...

Mon, 28 Apr 2008 21:20:55 +0000

Author: msotocl
Subject: 10180
Posted: 28 April 2008 at 9:20pm

Hi.

i not undestand your example...

please see the image:

i need make a filter only on column selected: In this case Column "Nombre Producto". I write a text in superior right text box and need, what the report control only search the text in selected column ("Nombre Producto")

any idea

thank you very much

FilterText question : Hi NightHawk Did you try this...

Tue, 22 Apr 2008 08:27:20 +0000

Author: Aaron
Subject: 10180
Posted: 22 April 2008 at 8:27am

Hi NightHawk

Did you try this with 1,5 million records? With my solution it doesn't matter if there are 10.000.000 records or just 1

FilterText question : You can write your own custom...

Mon, 21 Apr 2008 20:27:56 +0000

Author: nighthawk
Subject: 10180
Posted: 21 April 2008 at 8:27pm

You can write your own custom filter function. Here is a modified version of what I use. I didn't actually test this version so there may be a bug or two that needs worked out:

Private Sub filterRows2(p_objGrid As XtremeReportControl.ReportControl, p_strFilterText As String, p_lngColumnID As Long)
    Dim Record As XtremeReportControl.ReportRecord
    Dim i As Long
    Dim strValue As String
    Dim strCaption As String
    Dim bolVisible As Boolean

    On Error GoTo filterRows2_Error

    ' initially make all records visible
    For i = 0 To p_objGrid.Records.Count - 1
        Set Record = p_objGrid.Records(i)
        Record.Visible = True
    Next i

    If (p_strFilterText <> "") Then

        'loop through all rows and check filter text against value and caption of specified column
        For i = 0 To p_objGrid.Records.Count - 1
            Set Record = p_objGrid.Records(i)

            strValue = Record.Item(p_lngColumnID).Value
            strCaption = Record.Item(p_lngColumnID).Caption

            If ((isStringInString(LCase$(p_strFilterText), LCase$(strValue)) = True) Or _
                (isStringInString(LCase$(p_strFilterText), LCase$(strCaption)) = True)) Then

                Record.Visible = True
            Else
                Record.Visible = False
            End If
        Next i

    End If

    Set Record = Nothing
    p_objGrid.Populate

    On Error GoTo 0
    Exit Sub

filterRows2_Error:

End Sub

Public Function isStringInString(p_strIsThisString As String, p_strInThisString As String) As Boolean

    On Error GoTo isStringInString_Error

    If (InStr(p_strInThisString, p_strIsThisString) <> 0) Then
        'if not 0, then it is in target string
        isStringInString = True
    Else
        'if equals 0, then not in string
        isStringInString = False
    End If


    On Error GoTo 0
    Exit Function

isStringInString_Error:
    isStringInString = False
End Function

FilterText question : Hi, I guess it's not possible...

Mon, 21 Apr 2008 02:34:29 +0000

Author: Aaron
Subject: 10180
Posted: 21 April 2008 at 2:34am

Hi,

I guess it's not possible to filter on just 1 colum. The filter applies on every column in the ReportControl. I don't know what you need this for but you could add some code in the BeforeDrawRow event to "filter" the column you want.

If Item.Index = 1 Then
If Metrics.Text Like "*" & wndReportControl.FilterText & "*" Then
Metrics.Font.Bold = True

Else

Metrics.Font.Bold = False

End If
End If

FilterText question : Hi,I have a version 11.2. (Good...

Thu, 10 Apr 2008 17:12:14 +0000

Author: msotocl
Subject: 10180
Posted: 10 April 2008 at 5:12pm

Hi,

I have a version 11.2. (Good version), i have a 2 question:

1.- how to make a search of filltertext but only of selected column

2.- How to make a fixedrows (how to subtotals), but displayed in the end of a sumatory i.e, not only in header or footer

Thank you very much