By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,763 Members | 1,609 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,763 IT Pros & Developers. It's quick & easy.

NullReferenceException when using crystalReportViewer.ReportSource

P: n/a
I am using VS.NET 2003 with crystal reports XI release 2. I get a
runtime error at the following line:

oRptForm.crystalReportViewer.ReportSource = oReport
An unhandled exception of type 'System.ExecutionEngineException'
occurred in mscorlib.dll

If I put the following statement inside a try catch block, it gives me
a
NullReferenceException. I have checked oReport to see that it has data.
Please help me with this.

Thanks for your help

Aug 15 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
roopsd wrote:
I am using VS.NET 2003 with crystal reports XI release 2. I get a
runtime error at the following line:

oRptForm.crystalReportViewer.ReportSource = oReport
An unhandled exception of type 'System.ExecutionEngineException'
occurred in mscorlib.dll

If I put the following statement inside a try catch block, it gives me
a
NullReferenceException. I have checked oReport to see that it has data.
Please help me with this.

Thanks for your help
Can you post some of your code please?
Aug 15 '06 #2

P: n/a
The following line is where it errors giving a null reference
exception:
oRptForm.crystalReportViewer.ReportSource = oReport

I have tried binding the oDataSet to a datagrid, it does show me 2
tables of values.

Private Sub btnShowReport_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btnShowReport.Click

Dim oDataSet As New ProductivityDataSet()
Dim oReport As New Productivity()
Dim oProductivityReport As New
GsaVoldrBiz.ProductivityReport()
Dim oRptForm As ImmWinForms.ReportViewer

Status.ShowStatus("Generating Productivity Report...")
Me.Cursor = Cursors.WaitCursor

oProductivityReport.GetProductivityReport(oDataSet ,
dtpStartDate.Value, dtpEndDate.Value)
If oDataSet.Productivity.Rows.Count 0 Then
Status.ShowStatus("Loading Productivity Report...")
oReport.SetDataSource(oDataSet)
oReport.SummaryInfo.ReportTitle = "Productivity Report"
oReport.SummaryInfo.ReportComments = "Start Date: " &
dtpStartDate.Text & " End Date: " & dtpEndDate.Text
'Create the Report Form
oRptForm =
ImmWinApplication.AddForm("ProductivityReport",
GetType(ImmWinForms.ReportViewer))

'Set the properties of the Report Form
oRptForm.Text = "Productivity Report"
oRptForm.crystalReportViewer.ShowCloseButton = False
oRptForm.crystalReportViewer.ShowGroupTreeButton =
False
oRptForm.crystalReportViewer.DisplayGroupTree = False
'oRptForm.crystalReportViewer.ReportSource = oReport
Try
DataGrid1.DataSource = oDataSet

oRptForm.crystalReportViewer.ReportSource = oReport
Catch ex As NullReferenceException

End Try
'Me.Cursor = Cursors.Default
'Status.HideStatus()
'Me.Close()
Else
Me.Cursor = Cursors.Default
Status.HideStatus()
MessageBox.Show("There are no records to report on,
please adjust your query and try again", "Search Results",
MessageBoxButtons.OK, MessageBoxIcon.Information)
End If

End Sub
End Class

End Namespace


roopsd wrote:
I am using VS.NET 2003 with crystal reports XI release 2. I get a
runtime error at the following line:

oRptForm.crystalReportViewer.ReportSource = oReport
An unhandled exception of type 'System.ExecutionEngineException'
occurred in mscorlib.dll

If I put the following statement inside a try catch block, it gives me
a
NullReferenceException. I have checked oReport to see that it has data.
Please help me with this.

Thanks for your help
Aug 16 '06 #3

P: n/a
Hi!
Thank you for looking at it.

I get a NullReferenceException at the following line:
oRptForm.crystalReportViewer.ReportSource = oReport

I have tried binding the oDataset to datagrid to make sure it has data,
it does show 2 tables with data.

Please advice what I should do.

Thank you.
Private Sub btnShowReport_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btnShowReport.Click

Dim oDataSet As New ProductivityDataSet()
Dim oReport As New Productivity()
Dim oProductivityReport As New
GsaVoldrBiz.ProductivityReport()
Dim oRptForm As ImmWinForms.ReportViewer

Status.ShowStatus("Generating Productivity Report...")
Me.Cursor = Cursors.WaitCursor

oProductivityReport.GetProductivityReport(oDataSet ,
dtpStartDate.Value, dtpEndDate.Value)
If oDataSet.Productivity.Rows.Count 0 Then
Status.ShowStatus("Loading Productivity Report...")
oReport.SetDataSource(oDataSet)
oReport.SummaryInfo.ReportTitle = "Productivity Report"
oReport.SummaryInfo.ReportComments = "Start Date: " &
dtpStartDate.Text & " End Date: " & dtpEndDate.Text
'Create the Report Form
oRptForm =
ImmWinApplication.AddForm("ProductivityReport",
GetType(ImmWinForms.ReportViewer))

'Set the properties of the Report Form
oRptForm.Text = "Productivity Report"
oRptForm.crystalReportViewer.ShowCloseButton = False
oRptForm.crystalReportViewer.ShowGroupTreeButton =
False
oRptForm.crystalReportViewer.DisplayGroupTree = False
'oRptForm.crystalReportViewer.ReportSource = oReport
Try
DataGrid1.DataSource = oDataSet

oRptForm.crystalReportViewer.ReportSource = oReport
Catch ex As NullReferenceException

End Try
'Me.Cursor = Cursors.Default
'Status.HideStatus()
'Me.Close()
Else
Me.Cursor = Cursors.Default
Status.HideStatus()
MessageBox.Show("There are no records to report on,
please adjust your query and try again", "Search Results",
MessageBoxButtons.OK, MessageBoxIcon.Information)
End If

End Sub
End Class

End Namespace

Ray Booysen wrote:
roopsd wrote:
I am using VS.NET 2003 with crystal reports XI release 2. I get a
runtime error at the following line:

oRptForm.crystalReportViewer.ReportSource = oReport
An unhandled exception of type 'System.ExecutionEngineException'
occurred in mscorlib.dll

If I put the following statement inside a try catch block, it gives me
a
NullReferenceException. I have checked oReport to see that it has data.
Please help me with this.

Thanks for your help
Can you post some of your code please?
Aug 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more ASP.NET Questions on Bytes