Solved: Issue when using Orderby with the option FALSE ins... - Page 2

maretec

I'm using the "OrderBy" function to sort the [Fecha] column, highlighted in yellow. "Fecha" means Date.

The date format is day/month/year.

If set to TRUE, it works correctly (descending order).

But if set to FALSE, all items are in the correct order except the last one.

I changed the order from FALSE to TRUE and vice versa several times, but the results were the same.

Any ideas to fix this?

Suvrutt_Gurjar

Please try below.

1) In the "Cargos" table, please add a column called say [Insurer_Name] with an expression something like [Reclamo ID].[Insurer_Table_Key]

2) Now the template expressions can be something like below

In the template below, [Aseguradora Name] is assumed to be the name column of the insurer.

Aseguradora : <<[Aseguradora ID].[Aseguradora Name]>>

Fecha

Placa

Auto

Reclamo

other columns

Debito

<<Start: ORDERBY(SELECT(Cargos[Cargos Table Key],[Insurer_Name]=[_THISROW].[Aseguradora ID]), [Fecha], FALSE)>>

<<[Fecha]>>

<<[Placa]>>

<<[Auto]>>

<<[Reclamo ID].[Reclamo Number]>>

.........

<<[Monto]>>

<<END>>

Edit: Made some changes to make the approach simpler.

Issue when using Orderby with the option FALSE inside a Start End expression