subreport problem

[nikol]

Hi,
I have 2 subreports with 2 parameter fields city & date range. These parameters r static parameters (means I have created a notepad with list of cities & import them to parameter field same with dates parameter.I want 2 date ranges Minimum date & maximum date coz I want to display clients within that date ranges only & selected city. daterange parameter has "datetime" type
I have written record selection formula as

({table.city} = {?parameter.city}
or
{?parameter.city} = "All Cities")
and
{table.date} = Minimum({?parameter.date})
and
{table.date} = Maximum({?parameter.date))
for 2 subreports & main report also then I have selected
"field to link to" as Parameter fields & link them to date & city field in the subreports..
When I refresh the reports itys not giving anything.
Any help!!

 

[lbass]

You are setting the date to both the minimum AND the maximum. You need to change this to >= and <= in the main report. In your subreports, check the record selection formula to make sure they also contain >= and <=.

-LB