Report Parameter Month Order Need QuaterWise

  • Hi,

    I have to create one report inside that report using parameters(Month,Quarterwise). Month Parameter Order Coming Ascending to Descending Order,But i need Quarterwise month Order(Quarter 1:April,May,June).Can you Please help me on this.

    Regards,

    Raghav.

  • How did you create the parameters?

    What did you configure for the value of the parameter and what for the label?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi ,

    Here i am using MDX Queries,Manually Created Report parameters, after that mapping to Dataset Query parameters.

    Report parameter level using Avaliable Values -> Sql Query ->selecting parameter Dataset and Value filed(ParameterValue),Label filed(ParameterCaptionIndented).

    Regards,

    Raghav.

  • raghavag7 (8/25/2014)


    Hi ,

    Here i am using MDX Queries,Manually Created Report parameters, after that mapping to Dataset Query parameters.

    Report parameter level using Avaliable Values -> Sql Query ->selecting parameter Dataset and Value filed(ParameterValue),Label filed(ParameterCaptionIndented).

    Is the data sorted in the MDX query?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Can you please give one sample MDX Query?

Viewing 5 posts - 1 through 4 (of 4 total)

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