Results 1 to 3 of 3

Thread: How to combine ADO and DataReport in VB?

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2000
    Posts
    13

    Unhappy

    Thanks jtm7699 for his suggestions.
    My problem is that i want to change DataReport 's DataSource to a ADO recordset,but failed.Is this the limitation of DataReport?
    Any resolutions for changeable data source for report print?
    My datasource is Access Database.
    For any suggestions , thanks beforehand.

  2. #2
    Lively Member Kersey's Avatar
    Join Date
    Jun 1999
    Location
    The Netherlands
    Posts
    101
    Just use a disconnected rs (ADO ) !
    try something like this :

    dim x as rpttextbox
    dim y as rptlabel
    with rpt
    set .datasource = rs
    set x = .sections("section1").controls("txtfirstfield")
    x.datafield = "data"
    set y = .sections("section1").controls("lblfieldname")
    y.caption = "name of Field"
    .show
    end with

    set x =nothing
    set y =nothing

    repeat x,y for all txtboxes/labels
    x.datafield is the column name of the rs.

    goodluck

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2000
    Posts
    13

    Wink edition 8

    Thank u very much.
    My report edition is 8,i'm not familiar with it.
    I can't find the label in it.
    And i can't find the add-in of crystal report in VB IDE after installed the report software.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width