Post reply

Parameter date range inclusive syntax in URL string

  • December 22, 2011 at 2:26 pm

    #247984

    I have a parameter in a report (SSAS data source) that is defined as a date range inclusive. In the query designer it only list one parameter. When you view the report data window, it list in the parameters section two parameters in my case FromDimTimeDate and ToDinTimeDate.

    In the query designer section the one parameter is

    Dim_Time for dimension and Date under the Hierarchy.

    My question is how do I define this in a URL string ? This is what I tried

    &FromDimTimeDate=[Dim_Time].[From Date].%26[1/2/2010]

    I get value provided for the parameter is invalid.....

    Any help apprecaited

  • December 23, 2011 at 10:15 am

    #1425224

    jnawrocki (12/22/2011)

    I have a parameter in a report (SSAS data source) that is defined as a date range inclusive. In the query designer it only list one parameter. When you view the report data window, it list in the parameters section two parameters in my case FromDimTimeDate and ToDinTimeDate.

    In the query designer section the one parameter is

    Dim_Time for dimension and Date under the Hierarchy.

    My question is how do I define this in a URL string ? This is what I tried

    &FromDimTimeDate=[Dim_Time].[From Date].%26[1/2/2010]

    I get value provided for the parameter is invalid.....

    Any help apprecaited

    Give the following a try: &FromDimTimeDate="1/2/2010" (maybe without the double quotes)

    Not sure if it will work, but worth a shot.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply