DataGride Vs Datareport - AndreaVB Visual Basic and VB.NET source code discussion board

AndreaVB Forum : Reporting tools : DataGride Vs Datareport

Poster

Message

jonybd
Level: Master

Registered: 18-01-2005
Posts: 119

Ads by Lake Quincy Media

DataGride Vs Datareport

i am trying to use vb datareport to open FlexGride data for print. any idea how to resolve this.

            Dim i As Integer

            With from1.flexgrid1

                    For i = 1 To from1.flexgrid1.Rows - 1

                        If (from1.flexgrid1.TextMatrix(i, 0) = "") Then

                                Exit Function

                        Else

                            With DataReport1.Sections("Section1").Controls
                                .Item("Text1").DataField = from1.flexgrid1.TextMatrix(i, 0)

                            End With

                        End If

                        Set DataReport1.DataSource =
                        DataReport1.Show vbModal


            End With

29-09-2006 at 08:01 PM

Jihadalariqi
Level: Protégé

Registered: 18-12-2007
Posts: 7

Re: DataGride Vs Datareport

quote:
Set DataReport1.DataSource =

set the record set

like this

Private Sub Command2_Click()
Set cnn = New ADODB.Connection
Set rst = New ADODB.Recordset

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\small business.mdb;Persist Security Info=False"

rst.Open "SQL", cnn, adOpenStatic, adLockOptimistic

Set DataReport1.DataSource = rst
DataReport1.Show 1

End Sub

____________________________
vbboy

18-12-2007 at 10:29 PM

AndreaVB Forum : Reporting tools : DataGride Vs Datareport


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2010 Andrea Tincani