[RESOLVED] how to print data from datagrid using datareport?

[kirara22]

in my sreenshot it must print all what it is in in column1 which is:
aaa
bbb
ccc

DataReport6.Show

DataReport6.Sections("Section2").Controls("label1").Caption = DataGrid1.Columns(1)

plz help..

tnx..

[Hack]

Moved To Reporting

[kirara22]

oppss.. ok.. sorry..

plz help me..

[brucevde]

Add the appropriate controls to the Data Report at design time. Then simply use the code below to view the report.

Private Sub cmdPrint_Click()
    Set DataReport1.DataSource = DataGrid1.DataSource
    DataReport1.Show
End Sub

[kirara22]

Failed getting Rowset(s) from current data source

[brucevde]

Is the DataGrid attached to an ADO Data Control? If yes try this code

Private Sub cmdPrint_Click()
    Set DataReport1.DataSource = ADODC1.RecordSet
    DataReport1.Show
End Sub

[kirara22]

using that code it returns this error:

runtime error 3001 :
The application is using arguments that are of wrong type, are out of acceptable range, or are in conflict with one another

printing data on datagrid gives me headache

[brucevde]

What can I say! Everything I posted works fine for me.

I could keep on guesing and posting solutions but without more help from you it would be futile.

[rouzbeh_ziafati]

i want to show row number for each record that had fetched in report via data report
but i don't know how i can do this
each record in final report begin from number 1 ....

for example
1 jack robert 110 usa
2 nick stone 230 usa
.
.
.

[kirara22]

Private Sub cmdPrint_Click()

Do While DataGrid1.Columns(0) <> ""

DataReport6.Sections("Section2").Controls("label1").Caption = DataGrid1.Columns(1)

DataGrid1.Row = DataGrid1.Row + 1

Loop

End Sub

i try this code
but it gives me an error message:
run time error '6148'
invalid row number

in this line of code:

DataGrid1.Row = DataGrid1.Row + 1

plz help tnx.

[kirara22]

i've solved it already..hehehe

[dabeeyow]

can you show the code you used? thanks!

[chuckiechuckie]

i've solved it already..hehehe

mate! what code did you use! i have the same porblem as you! really need it (
thnx in advance!