set selection formula for subreport in Crystal reports using visual basic 6.0

[sapnapuranic]

Hello Experts,
I have designed a report using crystal reports 8.0.
There are subreports also included.front end is visual basic 6.0
I change the selection formula of the main report using
crystalreport.selectionformula. I am not knowing how to
set the selection formulae for the sub reports.
can any one help me .

[freewilly]

Hi s

You tell the Crystel report which subreport you want to change and simply make the changes to that sub report as if it were the main report. In the code below I set the SubreportToChange property to the correct sub report. I then set its selection formula, and then set the focus back to the main report with the last line.

CrystalReport1.SubreportToChange = <<sub report name>>
    CrystalReport1.SelectionFormula  = <<your selection formula>>
    CrystalReport1.SubreportToChange = ""

Good luck

FW

[phoohtoo]

Hi s

You tell the Crystel report which subreport you want to change and simply make the changes to that sub report as if it were the main report. In the code below I set the SubreportToChange property to the correct sub report. I then set its selection formula, and then set the focus back to the main report with the last line.

CrystalReport1.SubreportToChange = <<sub report name>>
    CrystalReport1.SelectionFormula  = <<your selection formula>>
    CrystalReport1.SubreportToChange = ""

Good luck

FW

Thanks a lot .

[Arsalan]

Please mark your thread resolved now