Problem with drill-through report parameters

[HFloyd]

Hello,

I am using sales data from a cube (MS Analysis Services). I have a report that compares sales for the current day of the month for several years. It shows the data in a matrix like this:

Parameters:
<choose the month #> (aka "5" for May) (single value)
<choose the years> (multi-value)

			
(Day)	2002		2003		2004
1	446,599		40,512		2,373
2	44,537		38,156		0     
3	75,971		98,052		179,076
4	8,315		0     		44,621
5	0     		284,328		50,536
6	180,233		66,426		42,621
7	253,009		34,756		29,417
...

What I want to happen, is that clicking on a value in the matrix would open a drill-through report that shows a list of orders for the date in question. For instance - clicking on the number "44,621" would open a report showing the orders for 5/4/2004.

I created the drill-through report and gave it three hidden parameters:
DateTypedCalendarMonth
DateTypedCalendarYear
DateTypedDayOfMonth

If I put in default values and run the report, it works fine.

On the main report, I set the Navigation for the textbox holding the value to "Jump to Report". The Parameters are set up like this:

DateTypedCalendarMonth	=Parameters!DateTypedCalendarMonth.Value(0)
DateTypedCalendarYear	=Fields!CalendarYear.Value
DateTypedDayOfMonth	=Fields!DayOfMonth.Value

However, when I run the report and click on a value I get this message:

The 'DateTypedCalendarYear' parameter is missing a value

I have no idea why this is happening, or what to do about it.

Any help, even out-there ideas is welcomed.

Thanks so much!

Heather

Floyd Innovations

http://www.floydinnovations.com