0

Print Layout: Sorting a subtable via a 'hidden' field?

Hi,

I have a print layout with a subtable which contains three columns. 

I need to sort the subtable output by a field which I don't want on the actual print layout, but if I don't have the field on the subtable layout, I can't sort by it. When I hide the column, the sorting defaults back to the main column and screws up the order I need the fields to appear.

Is there any way to sort the output without having the column of the sorting field? I thought about setting the column width to 0 on the print layout too, but it won't hide the field and you still see the column title, but 1 character wide.. 

Can anyone help please?

7replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Yes there is an answer but you won't particularly like it!

    Firstly - Ninox have yet to date not addressed the matter for formatting views on a print layout form - is has been on a wish list for ages - but ...
    Secondly you put the column that you don't want to display (but need to sort on) either as the first or last in the view. Then you drag (widen the view) so that column is off the page in the layout).

    Now it will work (however the limit on this is that if you add border grid lines around the the cells on the sub table /view etc then is shows the printed line going off the page!

    Do it like this (you can see my sort col (with 0,2 and 4 in it offf the page)

     

    border grid lines make it messy! as the rule will print off the page both on printer and pdf!

    Not elegant but at least it works

    Like
      • jason
      • jason.1
      • 3 mths ago
      • Reported - view

      Mel Charles Thanks Mel - That is, so far, the only fudge I've found too..  might have to use it though, for the time being. Thanks again!

      Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 3 mths ago
    • Reported - view

    There are any way to design report on landscape ?

    Like
  • Rafael Yes - I use several landscape forms...

    here is one (test)

    Just set the page boxes like this !! 297 in left box and 210 in right box on the designer

    Like
    • Rafael
    • Rafael Sanchis
    • Rafael_Sanchis
    • 3 mths ago
    • Reported - view

    Excelente Mel Thanks.

    Like 1
    • AlexisO
    • Sean_Wood
    • 1 mth ago
    • Reported - view

    I add a blank text box , then set the background to white and scale and position it to mask the column I wish to hide (placing that column at the end). It works and you can even get the borders to show with a bit of careful placing.

    Like 1
    • AlexisO - In the online web version that idea never saves - the text box colour always reverts to transparent despite ninox saying they would fix this some 2 years ago

      Like
Like Follow
  • 1 mth agoLast active
  • 7Replies
  • 70Views
  • 4 Following