I'm having trouble getting this report to work when using different data tables for some subreports. The thing that throws me off the most is that if I SetDataSource only once I don't get any errors but if I use two or more tables from the xsd the "Table [name] could not be found" error shows up.
This works (commenting one)
This also works (commenting the other)Code:'objReport.Subreports.Item("rptDailySummaryContractTracking").SetDataSource(dsResult.Tables("dtDailySummaryContractTracking")) objReport.Subreports.Item("rptDailySummaryDeposits").SetDataSource(dsResult.Tables("dtDailySummaryDeposits"))
But this doesn'tCode:objReport.Subreports.Item("rptDailySummaryContractTracking").SetDataSource(dsResult.Tables("dtDailySummaryContractTracking")) 'objReport.Subreports.Item("rptDailySummaryDeposits").SetDataSource(dsResult.Tables("dtDailySummaryDeposits"))
Any Ideas? I've looked and looked but can't find the reason it's not working.Code:objReport.Subreports.Item("rptDailySummaryContractTracking").SetDataSource(dsResult.Tables("dtDailySummaryContractTracking")) objReport.Subreports.Item("rptDailySummaryDeposits").SetDataSource(dsResult.Tables("dtDailySummaryDeposits"))
Thanks in advance!


Reply With Quote
