troubleshooting Question

Crystal reports report based on dataSet in VS 2005. How to.

Avatar of f_o_o_k_y
f_o_o_k_yFlag for Poland asked on
.NET ProgrammingCrystal ReportsVisual Basic.NET
2 Comments1 Solution962 ViewsLast Modified:
Hello,
I want to create report (crystal reports for VS 2005) based on DataSet.

I already done this:
1. Created stored procedure in MS Sql 2005
2. Created dataSet and drag'n'Drop stored procedure from serverExplorer
3. Created new crystal reports report:
    a) DatabaseFields -> Database Expert
    b) Project data -> ADO.Net DataSets -> <ProjectName>.ReportDataSet -> proc_Name
    c) Drag'n'drop each field into the report
4. Created form with CrystalReportViewer
5. added Dataset and bindingsource
6. write code (attached below)

After this I have Error.  "The report has no tables."

Can you help me with this?

Best Regards
FooKy
Private Sub CrystalReportViewer1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load
        Dim crd As CrystalDecisions.CrystalReports.Engine.ReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument()
        crd.Load("Raporty/rptList.rpt")
 
 
        Me.Rek_sel_WypelnijPodaniePrzyjeciaTableAdapter.Fill(Me.RaportyDataSet1.rek_sel_WypelnijPodaniePrzyjecia, 170, 1)
 
        crd.SetDataSource(RaportyDataSet1.Tables(0))
 
        CrystalReportViewer1.ReportSource = crd
 
 
    End Sub
ASKER CERTIFIED SOLUTION
Éric Moreau
Senior .Net Consultant
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros