Hi All, I am trying to assign date calendar for Creation Date column. Steps what I have taken are I used Range(Inclusive) for Creation Date Column in Query Designer. Deselected the available values from query option in both FromCreationDate and TOCreationDate Parameters. NO Default values were assigned. I modified the FromCreationDate and TOCreationDate parameter values in the main dataset as ="[OCP Date].[Standard Date].&[" + CStr(Format(Parameters!FromOCPDateStandardDate.Value, "mm/dd/yyyyT00:00:00"))+"]" ="[OCP Date].[Standard Date].&["+ CStr(Format(Parameters!ToOCPDateStandardDate.Value, "mm/dd/yyyyT00:00:00"))+ "]" However, I am getting the following error message An Error Occurred during local report processing An error has occured during local report processing Query execution failed for dataset 'x'. The Query (1,875) The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated. Further, I tried Format(CDate()), yyyy/dd/mmT00:00:00, and removed CONSTRAINED in the main query options but still facing the same error. This the format I have in CreationDate...[OCP Date].[Standard Date].&[01/01/1989] Any help would be really I appreciated. Thanks Tarak

Hi All, I forgot to remove the datasets for FromDate and ToDate. I did that and modified the parameter values as ="[OCP Date].[Standard Date].&["+Cdate(Format((Parameters!FromOCPDateStandardDate.Value),"mm/dd/yyyyT00:00:00"))+ "]" Now, I am getting this error The Value expression for the query parameter 'FromOCPDATESTANDARDDATE' contains an error: Conversion From String "00/01/2011T00:00:00" to type 'Date' is not valid. If I change the date values to previous year it is showing same message with that specified year. I checked in the data there are no values similar to that.

can you please post the format of the date you wish to see.It's bit confusing dudeDasari

Hi Jeevan, Thanks for the reply. I need MMDDYYYYT00:00:00 format. When I applied all known methods, it is not working that is what I am trying to say. I don't know where I went wrong. The following is the format I have it in Cube. [OCP Date].[Standard Date].&[01/01/1989] I appreciate your time on it. Thanks Tarakq

Hi Jeevan, Thanks for the reply. I need MMDDYYYYT00:00:00 format. When I applied all known methods, it is not working that is what I am trying to say. I don't know where I went wrong. The following is the format I have it in Cube. [OCP Date].[Standard Date].&[01/01/1989] I appreciate your time on it. Thanks Tarakq

Hi Tarak, in you expression you have done small mistake. do like this to get Date format =Format(Parameters!FromOCPDateStandardDate.Value,"MM/DD/YYYY") in you expression you have written mm that means minutes and MM represents Months. I hope this will solve you issue. All the best.Dasari

I used your query but it is throwing an error as The Query (1,982) restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated. However when I used the following queries, I am able to see data which was filtered by Month and Date not by YEAR. That means I am able to see the all year data. For example. if i use parameter values as 02/02/2010 and 02/28/2010 then it is showing Data OCPDATE 1200 02/02/2006 140 02/17/2007 20 02/28/2010 FromOCPDate="[OCP Date].[Standard Date]. &["+Format((Parameters!FromOCPDateStandardDate.Value), "MM/dd/yyyy")+"]" TOOCPDate="[OCP Date]. [Standard Date].&["+Format((Parameters!ToOCPDateStandardDate.Value), "MM/dd/yyyy")+ "] I don't know where I went wrong. I am trying to solve this from past three days. I appreciate your suggestions. Thanks Tarak.

Hi Tarakq, Here is a similar thread, you can take a look as a reference, MDX query to exclude a date range: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/af2e7886-4672-4194-8141-55ac43a05669 If you're still having trouble I suggest you post your question on the Analysis Services forum, because it seems you are now facing a MDX issue rather than a Reporting Services issue. If you have any question, please feel free to ask. Thanks, Eileen