ranking in ssrs?

• so.eslami

  SSChasing Mays

  Points: 604

  More actions

  July 23, 2012 at 11:22 am

  #264135

  i created below expression in a cells in tablix

  =code.ToArabicNumber(right(Format(iif(instr(join(Parameters!productfamily.Value,","),1)>0,CInt(Fields!MSC_hot_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),2)>0,CInt( Fields!MSC_cold_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),3)>0,CInt( Fields!MSC_galvanize_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),4)>0,CInt( Fields!MSC_tin_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),5)>0,CInt( Fields!MSC_colored_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),6)>0,CInt( Fields!MSC_acid_q.Value),0),"C0"),len(Format(iif(instr(join(Parameters!productfamily.Value,","),1)>0,CInt(Fields!MSC_hot_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),2)>0,CInt( Fields!MSC_cold_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),3)>0,CInt( Fields!MSC_galvanize_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),4)>0,CInt( Fields!MSC_tin_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),5)>0,CInt( Fields!MSC_colored_q.Value),0)+

  iif(instr(join(Parameters!productfamily.Value,","),6)>0,CInt( Fields!MSC_acid_q.Value),0),"C0"))-1))

  for example if the result of this expression be 400,300,100,100,...

  ranking is 1,2,3,3,..

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  July 23, 2012 at 11:38 am

  #1516379

  Is there a question here?

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/