I've tried both the ways i.e linked & Unlinked Subreport. The other approach I have not tried coz in case of main report I will need to hold a large dataset which holds some memory. Regards

Thanks for your suggestions. I am not creating new sub report. Sub report already exist in main report. The source parameter in this event is PageView. Regards

I have also tried this but it doesn't make any effect.

Hi, Thanks for your reply. Basically I need to change the datasource of an On-demand sub report in the Drill event of Group in the crystal report viewer. The first time when I set datasource to On-demand subreport it works perfectly and sub report load with the data. But next time when I set datasource to subreport the subreport doesn't come up with the new data. The code I m using to set datasource is :

Private Sub crView_Drill(ByVal source As Object, ByVal e As CrystalDecisions.Windows.Forms.DrillEventArgs) Handles crView.Drill

    Dim strsql As String
    Dim objUtil As New clsReportUtil
    Dim rpt As CrystalDecisions.CrystalReports.Engine.ReportDocument
    Dim ds As New DataSet

    rpt = Me.crView.ReportSource

    strsql = "Select \* From tblDeliveryOrderHead " \_
            & "INNER JOIN tblCustomer ON tblDeliveryOrderHead.CustomerID = tblCustomer.CustomerID " \_
            & "Where CustomerName = '" & e.NewGroupName & "' "
    ds = objUtil.GetDataSet(IBS\_Utility.clsUtLib.GetConnectionString, strsql)

rpt.Subreports(0).SetDataSource(ds)
Dim subc As New CrystalDecisions.Shared.SubreportContext()
subc.SubreportName = rpt.Subreports(0).Name
subc.PageNumber = CType(source, CrystalDecisions.Windows.Forms.PageView).GetCurrentPageNumber
subc.Position = New System.Drawing.Point(1827, 2889)

tN.GroupLevel = e.NewGroupLevel
tN.GroupName = e.NewGroupName
tN.GroupNamePath = e.NewGroupNamePath
tN.GroupPath = New Integer() {e.NewGroupPath}
subc.ContainingGroupInfo = tN

CTyp(source,CrystalDecisions.Windows.Forms.PageView).DrillDownOnSubreport(subc)

rpt.Refresh()
End Sub

Regards

Hello, I have a requirement of modifying the datasource of crystal report as per user select option from form. As records per each selection are too much which reduces the performance of application, so I need to do in this way. I tried to change the datasource by setting setdatasource command but it doesn't refresh the data in report. Thanks in advance Regards Ali Raza

Hello, I have a requirement of modifying the datasource of crystal report as per user select option from form. As records per each selection are too much which reduces the performance of application, so I need to do in this way. I tried to change the datasource by setting setdatasource command but it doesn't refresh the data in report. Thanks in advance Regards Ali Raza

Hello, I have a requirement of modifying the datasource of crystal report as per user select option from form. As records per each selection are too much which reduces the performance of application, so I need to do in this way. I tried to change the datasource by setting setdatasource command but it doesn't refresh the data in report. Thanks in advance Regards Ali Raza

I m setting dataset to main report using PUSH methods. Same way I want to set datasource to on-demand sub report at runtime on the basis of value from main report Regards

Hello I am using on-demand subreport in crystal report for the first time. Please help me on following problems. 1)I dont know exactly on which event to set datasource for on-demand subreport & how to set datasource for on-demand subreport. 2)How to get main report value against which I want to load subreport. Regards Ali Raza

Hi David, Thanks for your reply. Your second suggestion sounds better and I worked on it i.e On-demand subreport. The problems which I am facing in using on-demand sub report are following : 1) On which event should I set datasource for on-demands sub report. 2) How can I get the value from main report against which I filter datasource for on-demand subreport. As you said that you've worked on such report might be you give me a solution for my problems. Regards Ali Raza

Hello Friends, I have a requirement of my application to know whenever a user select a value on crystal report & getting the selected value from crystal report view to my .net application and using that value set datasource to sub report. Kindly help me how can I get the selected value from crystal report view to my application. Thanks in advance Regards

Hello Friends, I have a requirement of my application to know when user select a value on crystal report and getting the selected value from crystal report view to my .net application and using that value set data to be drill down. Kindly help me how can I get the selected value from crystal report view to my application. Thanks in advance Regards

Hello Friends, I have a requirement of getting the selected value from crystal report view to my .net application and using that value set datasource to other report. Kindly help me how can I get the selected value from crystal report view to my application. Thanks in advance Regards

Hello Friends, I have two applications in which one of them is build on VB6.0 & using Crystal Report 9.0 and the other application is build on VB.net and using .Net 2.0 Crystal Report. When running both applications on same machine the VB6.0(CR 9.0) application some times generate an error on opening report Error # -2147417848 : Method '~' of object '~' failed I need to know that can we run application with different version of crystal report on same machine and wat is the solution required to do it. Regards Ali Raza

Hello Friends, I have two applications in which one of them is build on VB6.0 & using Crystal Report 9.0 and the other application is build on VB.net and using .Net 2.0 Crystal Report. When running both applications on same machine the VB6.0(CR 9.0) application some times generate an error on opening report Error # -2147417848 : Method '~' of object '~' failed I need to know that can we run application with different version of crystal report on same machine and wat is the solution required to do it. Regards Ali Raza

Hi, Yes u can add quotes just by replacing single quote with double quote. Replacing will add only single quote in database. Example: strName=Xyz's "Insert into table1(Name) Values('" & Replace(strName,"'","''") & "')" Regards Ali Raza

Hello Friends, I have two applications in which one of them is build on VB6.0 & using Crystal Report 9.0 and the other application is build on VB.net and using .Net 2.0 Crystal Report. When running both applications on same machine the VB6.0(CR 9.0) application some times generate an error on opening report Error # -2147417848 : Method '~' of object '~' failed I need to know that can we run application with different version of crystal report on same machine and wat is the solution required to do it. Regards Ali Raza

Hello :) Try this that at the event of paint event of your tab page set its focus to some other or next object. Example: Private Sub tabpage1_Paint(ByVal sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles tabpage1.Paint tabpage2.Selected = True End Sub Regards Ali Raza

Hi Everyone :) I am developing a business application and wanna to include the facility of transactions in multiple units e.g (Customer can buy a Product in KG as well as in MG or GM). I am getting difficulties in managing stock if I allow user to apply transactions with multiple units. If anyone has some experienced in such transactions then please help me in developing this application. Regards

Hi EveryOne, Guys I need to deploy a .net2005 project that includes crystal reporting of .net also. I need to know which neccessary files required to be added in .net setup project coz setup project picks only CrystalDecision. CrystalReports. Design.dll. Also guide me one more thing that Is Crystal Report setup for .net 2005 is also required to be run with setup coz another application of VB 6.0 running on same PC that is using Crystal Reports 9.0 Kindly give me any idea regarding these problems. Regards Ali Raza