help with formula on main report

[CRuser89]

I have a report in CR9 with several subreports in it. I would like to filter based on what's in the main report record formula. Currently, the main report is passing the userid parameter to all the subreports. The subreports are then displaying all the dates and projects that the users have completed based on the userid parameter being passed.

I would like to add to the main report selection formula a date range so that if any project dates from the either on of the subreports fall within the date range, to display all the relevant information from all the subreports. So if subreport1 and subreport2 doesn't have any dates that fall in the range but subreport3 does, then all the current information will be pulled on all the subreports.

Right now the report is pulling all user information/project/and completion dates.

I added the following formula to the main report, however the data that is being pulled back is not complete. The conditions below are based on the formula conditions on the subreports. I broke the following formula into 3 sections so that you can see what I'm trying to do. Can you please tell me what I'm doing wrong?

({PROJECT.DATE_COM} >= {?BeginDate} and
{PROJECT.DATE_COM} <= {?EndDate} and
{JOB.TYPE} in ["2ND", "3RD"]) or

({TASK.DATE_COM} >= {?BeginDate} and
{TASK.DATE_COM} <= {?EndDate} and
{TASK.TASK_DESC} in ["COMP", "HR", "REC") or

({TASK.DATE_COM} >= {?BeginDate} and
{TASK.DATE_COM} <= {?EndDate} and
{TASK.TASK_DESC} = "ACCT" and
{JOB.TYPE} = '1ST')

 

[synapsevampire]

I'm having trouble understanding "So if subreport1 and subreport2 doesn't have any dates that fall in the range but subreport3 does, then all the current information will be pulled on all the subreports."

If there isn't any data for the dates specified for subreports 1 and 2, what dates would be used for subreports 1 and 2 if subreport 3 has data?

"current information" doesn't mean anything specific, please post specifics.

-k