RE: VB & CRYSTAL REPORT --TO QUERY ACCESS TABLE ??? STUCK !!!

[tomtan]

You can use the Selection Formula of the Crystal Report.

[Indraneel]

If you are using Crystal Report's OCX Control check with its selection criteria property which can be set within Visal Basic. For more help check on Developers.hlp in crystal directory.

Indraneel

[Negative0]

I always create a separate table for reporting, so I can format it the way I want. If you create a new table for this report, then you can clear the table, and fill it only with the records you need for the report.

Hope this helps,

[dcarlson]

I think the easiest way is to set your report datasource to a recordset that you create.

Such as:

    Dim rstCurrent As ADODB.Recordset
    Dim strSql As String
    Dim Report1 As rptClient

    Screen.MousePointer = vbHourglass
    
    strSql = "SELECT * FROM client WHERE lastname = 'Smith' ORDER BY firstname"
    
'Load a form with the reportviewer control on it.

    Load frmReport

'open your recordset

    Set rstCurrent = New ADODB.Recordset
    rstCurrent.Open strSql, fCnn1, adOpenForwardOnly, , adCmdText

'load your report

    Set Report1 = New rptClient

'set your report's datasource

    Report1.Database.SetDataSource rstCurrent

    frmReport.crvCommon.ReportSource = Report1

    frmReport.crvCommon.ViewReport

    frmReport.crvCommon.Visible = True

    frmReport.Show
    
    Screen.MousePointer = vbDefault

Hope this helps.