Partial Public Class DAReport
Inherits Telerik.Reporting.Report
Public Sub New(ByVal InvoiceID as integer)
InitializeComponent()
ShowInfo(InvoiceID)
End Sub
Sub ShowInfo(ByVal InvoiceID as integer)
Dim oView As System.Data.DataView = Nothing
Dim strQuery As String = "select * from invoice_lineItems where invid="& InvoiceID
Table1.DataSource = getDataSet(strQuery, "invoice_lineItems")
Table1.DataMember = "da_invoice_lineitems"
End Sub
Public Function getDataSet(ByVal strQuery As String, ByVal strTbl As String) As System.Data.DataSet
Dim ds As System.Data.DataSet = New DataSet
Try
Dim da As New MySqlDataAdapter
Dim bind As New BindingSource
Dim strConn As String = ConfigurationManager.AppSettings("ConnectionString")
Dim objConn As MySqlConnection = New MySqlConnection(strConn)
objConn.Open()
da = New MySqlDataAdapter(strQuery, objConn)
da.FillSchema(ds, SchemaType.Source, strTbl)
da.Fill(ds, strTbl)
objConn.Close()
Return ds
Catch ex As Exception
Return ds
End Try
End Function
End Class
Telerik.Reporting.Processing.
SubReport subReport;
subReport = (Telerik.Reporting.Processing.
SubReport)sender;
if (subReport.InnerReport.Items.Count == 0)
subReport.Visible =
false;
but it not working i need to know what should i do to make it hidden when no data