Hi all....I am trying to fill a report from a specified dataset. While debugging it gets the 77 rows but when creating the report it does not show nothing.

Please check my code

VB Code:
  1. Private Sub Report1()
  2.  
  3.         'RETRIEVE DATA FROM DATABASE
  4.  
  5.         Dim da As OleDb.OleDbDataAdapter
  6.         Dim cmd As OleDb.OleDbCommand
  7.         Dim dt As DataTable
  8.         Dim dr As DataRow
  9.         Dim ds As New DataSet
  10.         ds.ReadXmlSchema(Server.MapPath("Dataset1.xsd"))
  11.  
  12.         Dim objconn As New OleDb.OleDbConnection(strconn)
  13.         objconn.Open()
  14.  
  15.         cmd = New OleDb.OleDbCommand("Select * from Products")
  16.         cmd.Connection = objconn
  17.  
  18.         da = New OleDb.OleDbDataAdapter(cmd)
  19.  
  20.         da.Fill(ds, "Report")
  21.  
  22.         objconn.Close()
  23.  
  24.  
  25.         Dim crReportDocument1 As New ReportDocument
  26.         Dim crExportOptions As ExportOptions
  27.         Dim crDiskFileDestinationOptions As DiskFileDestinationOptions
  28.  
  29.         Dim Fname As String = Server.MapPath("Reports\T-Report.pdf")
  30.         crReportDocument1.Load(Server.MapPath("CrystalReport1.RPT"))
  31.  
  32.         Dim crTables As Tables
  33.         Dim crTable As Table
  34.  
  35.         crTables = crReportDocument1.Database.Tables
  36.         For Each crTable In crTables
  37.             crTable.SetDataSource(ds.Tables.Item(crTable.Name))
  38.         Next
  39.  
  40.  
  41.         'INITIALIZE EXPORT OPTIONS |
  42.         crDiskFileDestinationOptions = New DiskFileDestinationOptions
  43.         crDiskFileDestinationOptions.DiskFileName = Fname
  44.         crExportOptions = crReportDocument1.ExportOptions
  45.  
  46.         With crExportOptions
  47.             .DestinationOptions = crDiskFileDestinationOptions
  48.             .ExportDestinationType = .ExportDestinationType.DiskFile
  49.             .ExportFormatType = .ExportFormatType.PortableDocFormat
  50.         End With
  51.  
  52.         'EXPORT TO PDF
  53.         crReportDocument1.Export()
  54.  
  55.  
  56.     End Sub

btw...im connecting to the northwind database

Thanks