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