Hi Guys,

I had a requirement, 

we have two Types of Industry showing in Report,

Industry A have the following,

A,D,F,G,Y,Z

Industry B have the Following,

S,T

We need to show the Industry based report with ordering like,Indsutry A should appear first then,Industry b

for ex,

In X axis chart shows like, A,D,F,G,Y,Z,S,T

how to order like the above and show in chart.Since  both industry type appear in single column as "IndustryName","IndurtyID", columns -values as " A,D,F,S,T,G,Y,Z..",1,2,3,4,5,6,7,8

how to order based on showing "Industry type A" then show "Industry Type B"

Thanks,

R.B

Hi Bhupesh ,

Check the below link for some idea :

http://www.allaboutmssql.com/2013/06/ssrs-in-charts-how-to-sort-labels-on-x.html ..

Thanks

Rishab

Hi Rishab,

I have columns like Industry,IdustryID

with values,

A,D,F,S,T,G,Y,Z..",1,2,3,4,5,6,7,8

thanks

R.b

Hi R.B,

To achieve your requirement, we can refer to the following steps:

1. In the Category Groups, right-click the IndustryName group to open the Category Group Properties dialog box.
   
2. Click Sorting in the left pane, add the expression below as the Sort by column with A to Z Oder:
   =switch(trim(Fields!IndustryName.Value)="A",1, trim(Fields!IndustryName.Value)="D",2, trim(Fields!IndustryName.Value)="F",3, trim(Fields!IndustryName.Value)="G",4, trim(Fields!IndustryName.Value)="Y",5, trim(Fields!IndustryName.Value)="Z",6, trim(Fields!IndustryName.Value)="S",7, trim(Fields!IndustryName.Value)="T",8)

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong