Skip to Content
Former Member
Aug 13, 2008 at 07:15 PM

Using multiple date ranges in Desktop Intelligence report


I have two data providers which use multiple data ranges. In order to create an annualized value I am using Actual data activity for a YTD amount and then adding the Budget data activity for the remainder of the year.

In my example, the user is prompted for a From and To date range to be used in the Actual data provider (1/1/2008 and 6/30/2008). The next data provider requests a Budget From and To data (7/1/2008 and 12/31/2008).

I can run the data providers separately and return the correct results. However, I want the user to be able to use the "Refresh Data" icon and refresh all data providers simultaneously. The problem is that Desktop Intelligence is only prompting for a single set of From and To dates. Does anyone have a suggestion to force two sets of date prompts?