Sub Reports - Selection Formula

[yagnik3128]

If i want to pass the selectionformula for date range in sub report.

How is it possible. Cal anyone help me?

 

[pgtek]

hi

create your parameter in the main report
?BeginDate and the other ?EndDate

do the same in the sub report
?subBeginDate and ?subEndDate

link them
cheers

pgtek

 

[GJParker]

1. Create parameters for your start and en date in the main report i.e. ?StartDate and ?EndDate.

2. Go to Edit -> SubReport Links

3. select ?StartDate from the Available fields list and add that to the fields to link to

(crystal will automatically create a parameter in the subreport called ?Pm-?StartDate)

4. Select the Field from the subreport you want the dates based on.

5. Repeat steps 3 & 4 for the ?EndDate parameter and click OK

This will enter a selection formula in the subReport like

?StartDate={MyTable.fldDate} and ?EndDate={MyTable.fldDate}

you will need to manually edit this to change the comparison signs e.g.

?StartDate>={MyTable.fldDate} and ?EndDate<={MyTable.fldDate}

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[yagnik3128]

Hi pgtek,

I have done as per ur sugg. But now my problem is how to pass parameter value from vb?

Pl. Help me.