Hi - i'm a new user to this forum. I'm using VS2005
I have a report which takes information from an access database. The database has a password. I want the report to work without prompting the user for a password. Looking at various posting i've tried to make the report use a dataset for the datasource
Private Report32 As InspectorErrorReport
Dim Rdataset As ReportDataSet
Dim Rtable As ReportDataSet.InspectorFaultTableDataTable
Dim Radapter As ReportDataSetTableAdapters.InspectorFaultAdapter
Private Sub ReportForm_Load(ByVal sender As Object, ByVal e As system.EventArgs) Handles Me.Load
Rdataset = New ReportDataSet
Radapter = New ReportDataSetTableAdapters.InspectorFaultAdapter
Rtable = New ReportDataSet.InspectorFaultTableDataTable
Rtable.Clear()
Radapter.Fill(Rtable)
Report32 = New InspectorErrorReport
Report32.SetDataSource(Rtable)
CrystalReportViewer1.ReportSource = Report32
CrystalReportViewer1.DisplayGroupTree = False
End Sub
The error that i keep getting is
Overload resolution failed because no accessible 'SetDataSource' is most specific for these arguments: 'Public Overridable Sub SetDataSource(dataTable As System.Data.DataTable)': Not most specific. 'Public Overridable Sub SetDataSource(enumerable As System.Collections.IEnumerable)': Not most specific.
Please can anyone help. Thanks in advance