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

Printable View

Dec 1st, 2003, 10:58 AM
sapnapuranic

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

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 .
Dec 2nd, 2003, 01:24 AM
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.
VB Code:
```
CrystalReport1.SubreportToChange = <<sub report name>>
    CrystalReport1.SelectionFormula  = <<your selection formula>>
    CrystalReport1.SubreportToChange = ""
```
Good luck

FW
Feb 21st, 2014, 02:27 PM
phoohtoo

Re: set selection formula for subreport in Crystal reports using visual basic 6.0
Quote:
Originally Posted by 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.

VB Code:

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

Good luck

FW
Thanks a lot . :thumb:
Feb 22nd, 2014, 01:48 AM
Arsalan

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

Please mark your thread resolved now :)