Number of days issue

Hello everyone,

Here is my problem. My user wants to have the number of days in a report based of an interval dates from posting date.

This is simple enough, i can just uses a formula variable to give the difference between the dates.

But, if the user desided to drop in the posting period into the results rows, the user would like each period to show only the days in that period.

So 01/05/2001 - 03/01/2001

Would show a total 49

If the user puts period in the results the user wants to see

Period 1 Period 2 Period 3

26 28 1

Any ideas?

Thanks!!