I have two parameters defined in my report: FromDateShippedMonth and ToDateShippedMonth They have a default value of: [Date Invoiced].[Month].[All] Within the dataset I'm using to populate the report they are assigned the values: =Code.FiscalYearStart(Parameters!Division.Value,Parameters!DateShippedYear.Value,Parameters!Cal_Fisc.Value) & =Code.FiscalYearEnd(Parameters!Division.Value,Parameters!DateShippedYear.Value,Parameters!Cal_Fisc.Value) Before I "upgraded" to 2008, the report would run and the values calculated in the code block would be passed to the dataset parameters. The report wasn't returing the correct date range so I placed the parameter in the tablix to see what value was being calculated. The value was the default: [Date Invoiced].[Month].[All] Before, in 2005, the code block would take the data passed to it and return a starting and ending date range. Any idea why it wouldn't function like this in 2008? Query: SELECT NON EMPTY { [Measures].[Charge Weight],[Measures].[Charge Amount] } ON COLUMNS, NON EMPTY { ([Date Invoiced].[Year].[Year].ALLMEMBERS * [Date Invoiced].[Month].[Month].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@FromDateShippedMonth, CONSTRAINED) : STRTOMEMBER(@ToDateShippedMonth, CONSTRAINED) ) ON COLUMNS FROM[Heidtman DW]) WHERE ( IIF( STRTOSET(@Division, CONSTRAINED).Count = 1, STRTOSET(@Division, CONSTRAINED), [Organization].[Division].currentmember ) , IIF( STRTOSET(@CustomerName, CONSTRAINED).Count = 1, STRTOSET(@CustomerName, CONSTRAINED), [Customer].[Name].currentmember), [Coil Status].[SMSTS Code].&[Hist-Ship] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS (And now, unlike 2005, I have a bunch of temporary fields in my report because it has to "save itself" before preview....anyone else go back to SSRS 2005?????)

Hi I think, custom code related to Code needs to debug rather than MDX query here. Please check the Custom Code once, it could be great to have the code in case for further investigation.Prav

Sorry....never mind....something else is going on.......if a data point has a missing date it is included in the date range.......I'm going to have to find out what's going on with that but it's a different problem.