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: 28 March 2024 at 4:22pm
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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net