i am using MS-visual studio 2005 and VB.NET language in that.
my ques is tht i am unable to load a crystalreport.
all fields are shown from database (SQl SERVER 2005)
but data is not shown
so can anyone plz help??????????itz urgent

Recommended Answers

All 16 Replies

Please show some code.

How can we see what you did without seeing your code, or at least elaborate the problem a little.

Please show some code.

How can we see what you did without seeing your code, or at least elaborate the problem a little.

ya i am using sql server 2005 in wanted to display my table data int o crystal report
so all data is not gettin loaded just its field are gettin loaded like i hv wriiten code

Private Sub btnreport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnreport.Click
        Dim cryRpt As New ReportDocument
        cryRpt.Load("app path\CrystalReport1.rpt")
        CrystalReportViewer1.ReportSource = cryRpt
        CrystalReportViewer1.Refresh()
    End Sub

where is the code to load the fields?

Where is your data retrieval?

where is the code to load the fields?

Where is your data retrieval?

thtz wht the prob is dont have it


thtz what i want

Please ask specific questions, no1 will do your work for you.

What exactly is troubling you in this task?

Please ask specific questions, no1 will do your work for you.

What exactly is troubling you in this task?

i am really new to this crystal report so was not gettin anythg so just googled it and understud a little but its in my project so have to do it.

i tried this code for loadin :

Try
Dim con As New SqlConnection("conn str")
Dim cm As New SqlCommand
cm.Connection = con
cm.Connection.Open()
cm.CommandText = "Insert into table values(" & Val(txtbillno.Text) & ",'" & txtadd.Text & "','" & txtname.Text & "')"


cm.ExecuteNonQuery()

cm.CommandText = "Insert into CCO values(" & Val(txtadd.Text) & ")"

cm.ExecuteNonQuery()


Catch ex As Exception
MsgBox(ex.Message)
End Try

Me.Refresh()
Me.PrintDialog1.ShowDialog()


but still same prob is thr data doesnt gets load database fields are loadin.plz help
i m really depressed with it.

Sure I will help, I don't understand what you mean though?

Sure I will help, I don't understand what you mean though?

wht u didnt understud?????

OK lets do an exercise.

Can you tell me step by step what you have done in your code please use code tagging this time. and ' to add comments to what you have done.

Or write a pseudo code of what you want to do.

OK lets do an exercise.

Can you tell me step by step what you have done in your code please use code tagging this time. and ' to add comments to what you have done.

Or write a pseudo code of what you want to do.

ok then.i googled about crystal repot and whatever i have done is by this site below

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_step_by_step.htm

so just see it and tell what is going wrong?
every step in this site is followed by me but dont know whats happening?it doesnot show any errors nor any exceptions but then too the thing i want is not coming

plz help.....

Lets try and simply.

Can you do what I asked you to do in the earlier post.

The point of the exercise is to find out that you know exactly what you want.

Lets try and simply.

Can you do what I asked you to do in the earlier post.

The point of the exercise is to find out that you know exactly what you want.

yes i know what i want


i want my whole data to be displayed in crystal report thats it

Ok please write the pseudo code for that.

If you can't write the pseudo code for it I can't really help you.

Ok please write the pseudo code for that.

If you can't write the pseudo code for it I can't really help you.

Sorry for late repling but i got my problem solved
thanks for showing generosity and kindness

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.