Post reply

Interactive sorting

  • May 8, 2019 at 1:15 pm

    #3638293

    Is there anyway to sort in SSRS by reportitems.textbox.value?

    I have a report that a textbox does not appear in the dropdown for interactive sorting that has the following formula in it =(ReportItems!YTLP.value + ReportItems!TSA.value) / ReportItems!YT.value

    I would like to be able to sort this from largest to smallest value but I can not see any way of doing this

    Thanks

    Chris

  • May 8, 2019 at 1:42 pm

    #3638312

    hi Chris

     

    there's "fx" button next to the dropdown - you can try to specify your formula there

  • May 8, 2019 at 1:45 pm

    #3638313

    Hi Andrey

    I get the following error when I try that

    A sort expression for text box ‘Textbox26’ refers to a report item. Report items cannot be used in sort expressions.

  • May 8, 2019 at 2:07 pm

    #3638335

    another option is to add calculated field to the appropriate dataset

    however, it's not clear what are YTLP , TSA and YT items? how do they get values?

  • May 8, 2019 at 2:15 pm

    #3638337

    YTLP gets it total from =code.SumLookup(LookupSet(Fields!Fee_Ref.Value,Fields!Fee_Ref.Value,Fields!Split_Amount.Value, "Billing"))

    TSA =Sum(Fields!Total_Split_Amount.Value)

    YT  =Fields!Current_Annual_Budget___Billed_Time.Value

    I did try and put this in a calculated field which was my first option but I kept getting errors, which I assumed that calculated fields couldn't use the =code.

     

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

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