6 Replies Latest reply: Dec 21, 2016 12:26 PM by Gustavo S. RSS

    Automatic sorting in Straight or Pivot table

    Chris Hopkins

      Hi,

      I need help!!

      Is there a way of stopping the automatic sorting when i select a value within a straight or pivot table?

      I have a Straight table with transaction header details,

      i.e.

      RETAILER NAME, TILL NO, TRANSACTION ID, EMPLOYEE NAME, DATE, TIME, SALES AMOUNT.

      As the user scrolls through the table to look for a transaction, when they find it and select it, another straight table appears showing the products bought, price, qty etc.

      The problem i have is that as soon as the user selects the transaction they wish to look at (in the header), all other header details dissappear and the one selected moves to the top. If the user then wants to look at the next transaction, they have to start back at the top and scroll back down.

      I am wondering if there is a sort expression i could use to stop it from changing so that the user could select one after the other without having to scroll through the list again.

      Can anyone help please ?