Sort a table in Report

sharon95

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.

frankmortensen

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

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

The tablix can have sorting set on the groups also.

sharon95

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!