I have been evaluating Telerik reports for a few days now. I like what i want seen so far.bt i m facing a lil bit problem that some time when SQL query returns nothing then reporting process jst goes in to wait state.bt often it desplay the contents that no page to display bt some time it jst goes to wait state.normaly this prob. raise when Master report have a field be there is no field in subreport.the approach i m using is the following
Private Sub SubReport1_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles ItemQtyByContainerSubReport1.NeedDataSource
Dim subreport As Telerik.Reporting.Processing.Report = DirectCast(sender, Telerik.Reporting.Processing.Report)
cmd.CommandText = "SELECT ITM.ITM_NUMBER, ITM.ITM_NAME, SUM(PCQ.PCQ_QTY_IN_HAND * MFK.ITU_QUANTITY) AS Qty " & _
"FROM AFS_PCQ_PUR_CON_LINE_QTY_IN_HAND AS PCQ INNER JOIN " & _
"AFS_PUC_PURCHASE_CONTAINER AS PUC ON PCQ.PCQ_PUC_FK = PUC.PUC_ID INNER JOIN " & _
"AFS_ITM_ITEM AS ITM ON PCQ.PCQ_ITEM_NUMBER = ITM.ITM_NUMBER INNER JOIN " & _
"AFS_UOM_UNIT_OF_MEASURE AS UOM ON PCQ.PCQ_UOM_FK = UOM.UOM_ID INNER JOIN " & _
"AFS_ITU_ITEM_UNIT_OF_MEASURE AS MFK ON UOM.UOM_ID = MFK.ITU_UOM_FK AND ITM.ITM_ID = MFK.ITU_ITM_FK " & _
"WHERE (PCQ.PCQ_QTY_IN_HAND > 0) " & _
"GROUP BY PUC.PUC_CONTAINER_NUMBER, ITM.ITM_NUMBER, ITM.ITM_NAME " & HavingClause
adapter = New SqlDataAdapter(cmd.CommandText, sConnectionString)
adapter.Fill(ds)
subreport.DataSource = ds.Tables(0).DefaultView
End Sub