Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Parameter Month Order Need QuaterWise Expand / Collapse
Author
Message
Posted Monday, August 25, 2014 4:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:40 AM
Points: 14, Visits: 94
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.
Post #1607004
Posted Monday, August 25, 2014 4:16 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 13,261, Visits: 11,051
How did you create the parameters?
What did you configure for the value of the parameter and what for the label?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1607005
Posted Monday, August 25, 2014 6:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:40 AM
Points: 14, Visits: 94
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.
Post #1607033
Posted Monday, August 25, 2014 6:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 13,261, Visits: 11,051
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1607044
Posted Monday, August 25, 2014 9:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:40 AM
Points: 14, Visits: 94
Can you please give one sample MDX Query?
Post #1607323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse