Hello,
I have a report where I am combining two independent reports together.
The main report doesn't have any data sources; they are only on the sub reports.
Both sub reports use the same dataset that contains three tables.
I am getting the error Object reference not set to an instance of an object when I run the code below:
Code:
objRpt = New rptOVERDET
objRpt.SummaryInfo.Dispose()
objRpt.Subreports("srOverview").SetDataSource(dsDetail)
objRpt.Subreports("srOverview").SummaryInfo.Dispose()
objRpt.Subreports("srOverview").SummaryInfo.ReportComments = "Overview Report" & Trim(strReportHeader) & vbNewLine & Trim(strContactPhone)
objRpt.Subreports("srDetail").SetDataSource(dsDetail)
objRpt.Subreports("srDetail").SummaryInfo.Dispose()
objRpt.Subreports("srDetail").SummaryInfo.ReportComments = "Detail Report" & Trim(strReportHeader) & vbNewLine & Trim(strContactPhone)
Any help would be greatly appreciated.
Eddi Rae