Report Control - Report control instead of listview

Print Page | Close Window

Report control instead of listview

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=13356
Printed Date: 20 July 2025 at 4:40pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Report control instead of listview

Posted By: cjzer
Subject: Report control instead of listview
Date Posted: 07 February 2009 at 9:28am

Public Sub Populate()
Dim i As Integer
    Set rs = New ADODB.Recordset
    'If rs.State = 1 Then rs.Close
    rs.Open "SELECT DISTINCT studentno, fname FROM studentinfo;", db, adOpenDynamic, adLockPessimistic
    lstSubject.ListItems.Clear
    i = 1
    While rs.EOF = False
        lstSubject.ListItems.Add
        lstSubject.ListItems(i).Text = rs(0)
        lstSubject.ListItems(i).SubItems(1) = rs(1)
        i = i + 1
        rs.MoveNext
    Wend
    rs.Close
    Set rs = Nothing

End Sub
'==================================================

I used the code above but it won't work when I use it to the report control...
I'm confused ... I can't understand the samples of report control please help

I want to use the report control using the recordset.

Please help for the codes...

thanks...

Replies:

Posted By: Aaron
Date Posted: 10 February 2009 at 12:26pm

Hi,

There are samples in Sample forum: https://forum.codejock.com/forum_posts.asp?TID=11178 - https://forum.codejock.com/forum_posts.asp?TID=11178

-------------
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....

Posted By: cjzer
Date Posted: 11 February 2009 at 12:00am

thanks...