I have a "Load report failed" error when I deploy an application with a viewer using crystal reports 9. Im using an ADO.NET dataset to feed data to the report. The application works great on my PC even when installed, however not on any with only the .net framework. Even the simpliest application, created with the help files examples.
I am using vb.net.. and not the full vs.net you may be thinking of, but the stripped down VB only version.. This means by default that C++/C#/etc are not installed, which includes the vs.net standard crystal reports package. (Pretty sure this means the files normally in programfiles\common files\crystal decisions\1.0 are non existant)
So then, it was decided I needed to do reporting with crystal reports and so they gave me CR 9 Developer. CR9 apparently has a new version for their libraries, all in the newly created 2.0 dir at the above path. The problem now was that CR9 could not load crdb_adoplus.dll, because it didnt exist. (Im guessing because the 1.0 version wasnt there, it didnt load the new 2.0 at install. Also it wasnt even an installation option to install for a datasource?). However it still installed vs.net things such as help, an option to add crystal reports to a project, etc.
Ok so I found a hotfix on crystaldecisions.com which was similar. This patch needed an old version of crdb_adoplus.dll to uncompress its new files, which I didnt have. As per the suggestion on the page, I put a 1.0 version of the dll obtained from another computer and placed it the 2.0 dir. Ran the update, bingo the latest version of crdb_adoplus.dll. The update is at http://support.crystaldecisions.com/library/kbase/articles/c2013231.asp
Now everything was working great so I developed my app. It uses a MS Access database for input. However, even creating a simple app with only a viewer does the same thing, it will receives the same error as my application when installed on a .net only machine. I will include it in the hope that someone will recognize I have some property set wrong.
I have included a small sample database in the file as well
My guess is that it is not packaging something needed from the full version visual studio installation?
Please help,
-Nathan
p.s. the main part of the sample program goes like this:
(crystalreportviewer1 is a viewer, reportDataSet is from the "summary report" table. I have a feeling its not this code, but how I have the project set up.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.ShowDialog()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & OpenFileDialog1.FileName)
Dim adapter As New OleDbDataAdapter
adapter.SelectCommand = New OleDbCommand("SELECT * FROM [Summary Report]", conn)
Dim reportDataSet As DataSet = New Dataset1
adapter.Fill(reportDataSet, "Summary Report")
Dim rpt As ReportDocument = New CrystalReport1
rpt.SetDataSource(reportDataSet)
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.Update()
End Sub
I am using vb.net.. and not the full vs.net you may be thinking of, but the stripped down VB only version.. This means by default that C++/C#/etc are not installed, which includes the vs.net standard crystal reports package. (Pretty sure this means the files normally in programfiles\common files\crystal decisions\1.0 are non existant)
So then, it was decided I needed to do reporting with crystal reports and so they gave me CR 9 Developer. CR9 apparently has a new version for their libraries, all in the newly created 2.0 dir at the above path. The problem now was that CR9 could not load crdb_adoplus.dll, because it didnt exist. (Im guessing because the 1.0 version wasnt there, it didnt load the new 2.0 at install. Also it wasnt even an installation option to install for a datasource?). However it still installed vs.net things such as help, an option to add crystal reports to a project, etc.
Ok so I found a hotfix on crystaldecisions.com which was similar. This patch needed an old version of crdb_adoplus.dll to uncompress its new files, which I didnt have. As per the suggestion on the page, I put a 1.0 version of the dll obtained from another computer and placed it the 2.0 dir. Ran the update, bingo the latest version of crdb_adoplus.dll. The update is at http://support.crystaldecisions.com/library/kbase/articles/c2013231.asp
Now everything was working great so I developed my app. It uses a MS Access database for input. However, even creating a simple app with only a viewer does the same thing, it will receives the same error as my application when installed on a .net only machine. I will include it in the hope that someone will recognize I have some property set wrong.
I have included a small sample database in the file as well
My guess is that it is not packaging something needed from the full version visual studio installation?
Please help,
-Nathan
p.s. the main part of the sample program goes like this:
(crystalreportviewer1 is a viewer, reportDataSet is from the "summary report" table. I have a feeling its not this code, but how I have the project set up.)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.ShowDialog()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & OpenFileDialog1.FileName)
Dim adapter As New OleDbDataAdapter
adapter.SelectCommand = New OleDbCommand("SELECT * FROM [Summary Report]", conn)
Dim reportDataSet As DataSet = New Dataset1
adapter.Fill(reportDataSet, "Summary Report")
Dim rpt As ReportDocument = New CrystalReport1
rpt.SetDataSource(reportDataSet)
CrystalReportViewer1.ReportSource = rpt
CrystalReportViewer1.Update()
End Sub