This is a migrated thread and some comments may be shown as answers.

Generating Report Process jst Goes to Wait State

1 Answer 65 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Rehan
Top achievements
Rank 1
Rehan asked on 29 Jan 2008, 08:48 AM

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

1 Answer, 1 is accepted

Sort by
0
Rossen Hristov
Telerik team
answered on 29 Jan 2008, 10:10 AM
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
Tags
General Discussions
Asked by
Rehan
Top achievements
Rank 1
Answers by
Rossen Hristov
Telerik team
Share this question
or