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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Parameters in Crosstabs

Status
Not open for further replies.

gilsonr

Technical User
Mar 16, 2002
19
GB
Is it possible to use a date range parameter to controll a cross-tab report, if the cross-tab is in the report header.
 
Are you trying to limit only the crosstab, or all of the data in the report?

If all of the data, then use something like the following in the record selection formula (Report->Edit Selection Formula->Record):

{table.date} = {?dateparm}

If just the crosstab, then I think you'd be best served to create a subreport wherein the parameter is used and place that subreport in the Page Header of the main report.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top