Report Control - Is that possible to search within column

Print Page | Close Window

Is that possible to search within column

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=3520
Printed Date: 30 April 2025 at 12:34pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Is that possible to search within column

Posted By: debehs
Subject: Is that possible to search within column
Date Posted: 17 January 2006 at 3:32am

Hi,

in the ReportView, let say, I would like to search for a keyword call "cybeh", within column 1 in my Report view, and the search return a row number. Is that possible to make it?

Please advice. Thanks.

Replies:

Posted By: sserge
Date Posted: 18 January 2006 at 2:53pm

Hi,

Iterate all rows and find your one. Something like the following:


    Dim Row As ReportRow
    For Each Row In wndReportControl.Rows
      If Not Row.Record Is Nothing Then
        If InStr(1, Row.Record.Item(COLUMN_SUBJECT).Value, "cybeh", vbTextCompare) > 0 Then
              MsgBox Row.Index
        End If
      End If
    Next

--
WBR,
Serge

Posted By: debehs
Date Posted: 18 January 2006 at 10:05pm

Thanks.