السلام عليكم
first of all thanks about response but my brother i search about any example for reporting from more than table but i am not find so this the solution for single table
Dim rpt As New ReportDocument
Dim fileName As String = Server.MapPath("entdab_dakhli1.rpt")
rpt.Load(fileName)
'-------------------------------------------------------------------------------
Dim col As New EntedabMonyCollection
Dim selectFilter As New PredicateExpression
Dim sorter As SortExpression
Dim ahwalid As New TextBox
ahwalid.Text = 1
If Not [String].IsNullOrEmpty(ahwalid.Text) Then
selectFilter.AddWithAnd(EntedabMonyFields.EntedabType = ahwalid.Text)
End If
If Not [String].IsNullOrEmpty(TextBox5.Text) Then
selectFilter.AddWithAnd(EntedabMonyFields.DeputStart >= TextBox5.Text)
End If
sorter = Nothing
Dim dt As DataTable = EntedabMonyCollection.GetMultiAsDataTable(selectFilter, 0, Nothing)
rpt.SetDataSource(dt)
CrystalReportViewer1.ReportSource = rpt
this code work fine with single table but i do not know how to to make it work with multi table