Hi All...
I'm desparetly trying to use a stored procedure in a report, and i'm having some trouble. I'm using Visual Studion 2005 and I am coding in vb.net.
I create the report and add a data source (i do not use the wizard for this), which then creates a data set and a data set table adapter.
When select the data set, and click on Edit in DataSet designer, I select the DataSetTabelAdapter, and change the Command Type to Stored Procedure and I change the Command Text to the procedure name, it gives me a error in the backend vb code for this line of code:
Me.DataSetTableAdapter1.Fill(Me.DataSet.DataSetTable) - it say the DataSetTable is not a member of michelle_reports.DataSet
Can someone please please help with this? I would like my clients to enter only a reference number wich will then extract the given data form the database relating to that reference number.
I'm desparetly trying to use a stored procedure in a report, and i'm having some trouble. I'm using Visual Studion 2005 and I am coding in vb.net.
I create the report and add a data source (i do not use the wizard for this), which then creates a data set and a data set table adapter.
When select the data set, and click on Edit in DataSet designer, I select the DataSetTabelAdapter, and change the Command Type to Stored Procedure and I change the Command Text to the procedure name, it gives me a error in the backend vb code for this line of code:
Me.DataSetTableAdapter1.Fill(Me.DataSet.DataSetTable) - it say the DataSetTable is not a member of michelle_reports.DataSet
Can someone please please help with this? I would like my clients to enter only a reference number wich will then extract the given data form the database relating to that reference number.