Multiple Parms not working 1

[fcullari]

I have a report where I need multiple parameters and multiple formula's. My selection criteria is: {TASKS.HOURS} > 0 OR {TASKSACT.HOURS} > 0 and
{TASKS.RESPONS} = {?Tech } and
{TASKS.COMPLETED} >= {?FromDate} AND {TASKS.COMPLETED} <= {?ToDate} OR
({TASKSACT.COMPLETED}) >= ({?FromDate}) and ({TASKSACT.COMPLETED}) <= ({?ToDate})
This is for Track It data, and I need to get taskact(Subtask) hours if none use the Task hours, and then use parameters for From and To dates. The problem is that my parameters are not working. They all work individually but not when I put them together. Any ideas?

 

[dgillz]

Breaking down you formula at the ORs, you have the following:

{TASKS.HOURS} > 0

OR

{TASKSACT.HOURS} > 0 and
{TASKS.RESPONS} = {?Tech } and
{TASKS.COMPLETED}>={?FromDate} and
{TASKS.COMPLETED}<={?ToDate}

OR

({TASKSACT.COMPLETED})>=({?FromDate}) and ({TASKSACT.COMPLETED})<= ({?ToDate})

In the last part of your logic, you have told it that you want every single record where {tasksact.completed} is between the 2 dates, thus negating the {?Tech} parameter right above it.

Also, your first set of logic would include all records with a {tasks.hours}>0, regardless of the dates or {?Tech}.

What records do you want on your report?
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com