DESPERATE HELP NEEDED! Setting minimum to maximum levels.

[waikeana]

I have a report where I want the end-user to have the ability to select a range to view, based on a sum total. I've created the parameter (?Effort to Review) and I've also included the minimum to maximum range within the select expert, based on the calculated total (i.e., @Total Effort to Completion).

My problem is, although this works at the detail level I am unable to get it to work at the group level. At the group level this formula says:

Sum ({@Total Effort at Completion}, {S_WORK.PLACE7})

How do I get the report to actually show just a minimum to maximum (?Effort to Review) at the group level, versus the detail level?

I need this as soon as possible and can't really figure out how to write the explanation, nor come up with what my supervisor wants. I hope the above is good enough for someone to help me with.

I have 7 groups that I'm displaying, and I'm suppressing the detail line. If I say minimum range 100 to maximum range 1000, I am still getting results that are above and below my minimum to maximum ranges -- but its correct at the detail level. I need it to be correct at the group level, not detail level.

PLEASE HELP

 

[lbass]

Go to report->edit selection formula->GROUP and enter:

Sum ({@Total Effort at Completion}, {S_WORK.PLACE7}) in
{?Min} to {?Max}

-LB