Help with calculated data in my report... please it's URGENT!!!

Hi everybody,

Please I need some real help!!! I'm developing a Business Solution and one of my requirements is to show some reports. Until that it's OK.

But one of my reports must show some calculated data within a date range between today and 90 days before. Let me explain you this...

It's a performance report. It's about all the Orders made by the commercials (users) in my company. The structure of the report's data source is like this:

Status: 0=Delivered, 1=Accepted, 2=Rejected

What I need to show in my report is the Commercial's name, the number and sum of values of his (her) delivered, accepted and rejected Orders, and finally,the number of Orders having status0 in last 3 months and the sum of their respective Order Values(it should beindependent of filter date). Last 2 fields are called the "BackLog". All these values should be grouped by Division.So What I should get is something like this:

I'm assuming the reference day is today 07/25/05. So, as you can see, the backlog just must count (and sum) the Orders between 04/25/05 and 07/25/05.

You could think it's really easy (and... yeah! until here it's easy) but (there's always a but...) in my company we are managing this data since June, 2003. And this is a very oftenly used report (one of the topmost… if not the topmost). My boss wants to filter this report by an interval of dates, but when I do it, this filter reflects in the BackLog Fields.

I’ve been trying really hard to solve this little problem, but I just can’t figure it out…!!! Please help me, boys… I know you will. I’ll be waiting for your help, brothers… And beforehands… thank you all for your help and continuous support. Bye.

Я!??!? ?Я?ZΨ

[56032 byte] By [richie_crazy57] at [2007-12-16]