Sort a table in Report

sharon95
sharon95 Member Posts: 183
in NAV Three Tier
Hi all, I have to print a report showing a table sorted for a choosen field.
The table is sorted by default with the primary key, let's say "No.". I have to sort the table with another key, let's say "Posing Date". How can I do it?
Thanks.

Answers

  • frankmortensen
    frankmortensen Member Posts: 42
    Make sure the "Posting Date" field is in the dataset.
    Open the report layout.
    Find the tablix that is to be sorted.
    Select tablix properties - sorting.
    Add the "Posting Date".
  • sharon95
    sharon95 Member Posts: 183
    frankmortensen wrote: »
    Make sure the "Posting Date" field is in the dataset.
    Open the report layout.
    Find the tablix that is to be sorted.
    Select tablix properties - sorting.
    Add the "Posting Date".

    it doesn't work.. :(
  • frankmortensen
    frankmortensen Member Posts: 42
    The tablix can have sorting set on the groups also.
  • sharon95
    sharon95 Member Posts: 183
    frankmortensen wrote: »
    The tablix can have sorting set on the groups also.

    it works, but why I get a rendering output when I write the following expression for the sorting?
    =iif(Fields!SortingOrder.Value = 1,Fields!date.Value,Fields!DocumentNo.Value)
    thanks!

Categories