Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    CANADA
    Posts
    2

    Exclamation Visual Basic Data Report

    i was pondering, is it possible to create Visual Basic Data Report at runtime using ADO and SQL statements.
    any input will be appreciated

  2. #2
    Join Date
    Jan 2004
    Posts
    4

    Re: Visual Basic Data Report

    I want to view report using data report with a specified criteria
    how can i do

    that is i want to get only records between 2 dates

    acqua

  3. #3
    Join Date
    Jan 2004
    Location
    CANADA
    Posts
    2

    Lightbulb Data Report

    i dont know if it will help you but this is what i used to run my report in crystal and vb where a bunch of variables are used to form a sql string which is executed with command and data is put in a report.

    Set datcmd1 = New ADODB.Command
    Set datcmd1.ActiveConnection = cnn1
    datcmd1.CommandText = VehInfoRep.infosqlstr
    datcmd1.CommandType = adCmdText


    ' Add the datasource to the report
    m_Report.Database.AddADOCommand cnn1, datcmd1
    Set fld = m_Report.Section3.AddFieldObject("{ado." & valarr(0) & "}", 400, 0)

Posting Permissions

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