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!

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

Parameter - two fields

Status
Not open for further replies.

IceRuby

Technical User
Jan 20, 2004
85
AU
Crystal 11, ODBC to SQL 2000.

I have a large report, all data is derived by date range parameter from one database field - "processed period"

I need to insert a subreport which requires date criteria from two fields - "From" & "To"

I am unsure if or how I can utilise the one date range parameter when linking sub report.

Appreciate your assistance.
 
You can create the same range parameter within the subreport, add it to your subreport record selection formula, and then link the subreport parameter to the main report parameter. In the main report, go to edit->subreport links->add the main report parameter to the right, and then in the bottom left, use the dropdown list to select {?daterange}, not the default {?pm-?parameter}.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top