Generating Report Process jst Goes to Wait State

2 posts, 0 answers
  1. Rehan
    Rehan  avatar
    9 posts
    Member since:
    Jan 2008

    Posted 29 Jan 2008 Link to this post

    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

  2. Rossen Hristov
    Admin
    Rossen Hristov avatar
    2478 posts

    Posted 29 Jan 2008 Link to this post

    Hello Rehan,

    This was a know problem in an older version. Are using the latest version? In case you are and you are still experiencing the problem, can you please send us your whole report, along with the data source if possible, and the exact steps to reproduce it.

    We set up a small sample in which the subreport sometimes has data and sometimes does not -- but we could not reproduce the behavior you are facing -- the report was rendered without "hanging". Can you set a breakpoint in the NeedDataSource event handler and debug your application to see where exactly does it "hang". This might help us a lot.

    Greetings,
    Ross
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. DevCraft banner
Back to Top