Post reply

how sort report base on a text box in tablix descending

  • July 23, 2012 at 11:32 am

    #261512

    i created an expression in a cell in a tablix , i wanna sort the result of my report base on this expression descending

  • July 23, 2012 at 12:07 pm

    #1516401

    Use the same expression on the sort tab of the tablix properties

  • July 23, 2012 at 1:29 pm

    #1516443

    thank you, i do this but doesnt work correctly, i think this is for that my expressin is in currency mod and have comma between number

    this is my expression

    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)

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

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