• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

Failed to open a rowset Crystal reports


I have created a crystal report on my local windows application.  I used the  crystal wizard and got the parameters needed.

when I ran the report in the viewer I get this error

Failed to open a rowset  

this is all i used for code


 Dim rpt As New report1
CrystalReportViewer1.ReportSource = rpt


p.s. the database is not local

PLEASE HELP

I bought the crystal report book and followed the directions but still can't get it working

 
0
genesisproject
Asked:
genesisproject
  • 2
1 Solution
 
cyberdevil67Commented:
Hi genesisproject,

 is rpt.Load() loading your report? You might need to look at this

 Dim report as ReportDocument = new ReportDocument()
 report.Load(path\document.rpt)
 CrystalReportViewer.ReportSource = report

 Also if you have paramters you might need to also look at

 DatabaseLogin or is it Logon and SetParameters

Cheers!
0
 
cyberdevil67Commented:
the exact commands are

                Report.SetDatabaseLogon("username", "password")
                Report.SetParameterValue("CompanyCode", thisCompanyCode)
                Report.SetParameterValue("StartingInvoice", thisInvoice)
                Report.SetParameterValue("Reprint", True)
                Report.SetParameterValue("IsBranch", False)
                Report.SetParameterValue("PrintDiscount", False)
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now