Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selection Formula for Subreport.

Status
Not open for further replies.
yagnik3128

yagnik3128

Programmer
Jun 14, 2001
64
IN
Hello, I am a free lancer & using Crystal report with VB6.

I am passing date range through VB like

Cr1.SelectionFormula = "{FA16.FA16_2} in Date (" & MSDate & ") To Date (" & MEDate & ")"

Here FA16 is a table & FA16_2 is a field name. & msdate & medate are the strings which user will pass through a form.

I am passing this selectionformula in a main report. & it is working fine. I am calling 2 subreports in this main report & i have used some other tables in those reports. I want to pass a selection formula of date range in that subreports too through VB.

Please Help me.
 
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
410
TPG_IT
T
inkbird01
  • Locked
  • Question
Filters > Record Selection for dates between
Replies
4
Views
283
pmax9999
pmax9999
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
635
dgillz
dgillz
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
505
doodledump
D
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
319
john432
john432

Part and Inventory Search

Sponsor

Back
Top