VB.NET

VB.NET RSS

How can I generate report from data grid??

Please support our VB.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2007

Posts: 23

Reputation: Kshiteesh is an unknown quantity at this point

Solved Threads: 0

Kshiteesh

Offline

Newbie Poster

How can I generate report from data grid??

Aug 14th, 2007

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;

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
       <span class="ad_notxt"><code class="inlinecode">
 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
 </code></span>
    End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
       <span class="ad_notxt"><code class="inlinecode">
 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
 </code></span>
    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

•

Join Date: Jun 2007

Posts: 82

Reputation: preetham.saroja is an unknown quantity at this point

Solved Threads: 1

preetham.saroja preetham.saroja is offline

Offline

Junior Poster in Training

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

Aug 14th, 2007

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!!!!

•

Join Date: Jun 2007

Posts: 23

Reputation: Kshiteesh is an unknown quantity at this point

Solved Threads: 0

Kshiteesh

Offline

Newbie Poster

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

Aug 17th, 2007

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

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
[Salutation] [fname] [mname] [lname], [degree]
[Position]
[organisation]
[Street] [City] 
[State]
[Country]
Phone:[tel1] ,[tel2],[tel3]
Fax: [fax]
Email: [email]
URL: [url]
[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;

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
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
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