Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data from ADO.NET dataset not being displayed in report

Status
Not open for further replies.

anjroid

Programmer
Nov 20, 2002
3
US
I am working with Crystal Reports in Visual Studio .NET. I am creating my report off of an ADO.NET dataset. I created a stored procedure in the database I'm using. I also created an SQLDataAdapter that uses the stored procedure to fill the dataset. When I go to the WebForm in Design mode, I can preview the data in the SQLDataAdapter just fine. However, when I go to build and run it, the data does not show up in the report. Here is the code I used in the .vb file to bind the report to the Web Forms Viewer:
Dim oRpt As New SearchReport()
Dim searchDS As Dataset1 = New Dataset1()
SqlDataAdapter1.Fill(searchDS)
oRpt.SetDataSource(searchDS)
CrystalReportViewer1.ReportSource = oRpt (ANY SUGGESTIONS?)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top