How can I generate report from data grid??
 

Dear frens,

from your help I succeeded in creating data grid . Thank you for it.

Now i need to generate report from data grid.

my data grid code is as follows;

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

       

 Db1DataSet1.Clear()

        Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=K:\Database\db1.mdb"

        Dim con As OleDb.OleDbConnection = New OleDb.OleDbConnection(conStr)

        Dim S As String

        Dim datagrid1 As New DataGrid

        S = "select * from add1 where ID='" & TextBox1.Text & "'"

        Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(S, con)

        da.Fill(Db1DataSet1, "add1")

        datagrid1.DataSource = Db1DataSet1.DefaultViewManager

 

    End Sub

Now I want to generate report from the data field available in data grid in the form :
[Salutation] [fname] [mname] [lname], [degree]
[Position]
[organisation]
[Street] [City]
[State]
[Country]
Phone:[tel1] ,[tel2],[tel3]
Fax: [fax]
Email: [email]
URL: [URL]

I want to make two columns in the report to show various contacts' addresses in the data grid into printable form by generating report.

I don have any idea to generate report as i have never done it .

Please provide me with help with necessary explanations.

Anticipating for your help

Regards;
Kshiteesh

Re: How can I generate report from data grid??
 

hai,
first check out -crystal report is installed in ur system& if its yes-then connect crystal report with db(by clicking on source option-present in file,menu)
And also manually connect db with reports-by writing code invb.net....i think after that,u should b able todo!!!!

Re: How can I generate report from data grid??
 

Ya. thanks Pretham. saroja

I did as u said. But I have a problem while designing a report. I have to put different text fields in a format however the values have variable lengths.

I found trouble in managing the gaps between the fields. Is there any process or solution to make such that the values autoaccomodate the text boxes so that it looks like

[Salutation] [fname] [mname] [lname], [degree]

[Position]

[organisation]

[Street] [City] 

[State]

[Country]

Phone:[tel1] ,[tel2],[tel3]

Fax: [fax]

Email: [email]

URL: [url]

for example above format should show in report as;

Dr. Preetham Saroja, Phd(USA)

Executive Director

International Centre for Information Technology

16 Avenue Stree, Mery Land

12121WA, USA

Phone: 001923823283232, 0012832832382,001232323223

Fax: 00123237626322

Email: preetham.saroja@icit.org

URL: www.icit.org

But I have the difficulty , like when I design long name keeping in mind and use short name instead for eg: Ram instead of Gangottery. then
a problem exists the space between two field vaues broadens....

I m using VB.net version 8. I m using msaccess as bacend.

Please help me and provide me with necessary code if there is any. I have got just a week left for the deadline of my project.

Anticipating your reply

Kshiteesh

Re: How can I generate report from data grid??
 

How can I generate report from data gridview control

Re: How can I generate report from data grid??
 

How can I generate report from data gridview in vb.net.