Stimulsoft Business Intelligence System | Forum

Hi !! I´m trying to order some data in a report using the expression below in the before render event of a DataBand but it´s not working.

if DataBand.Date <= (01/03/2019){
DataBand.Sort = new string[] {"ASC","Clients.Name"};
}else{
DataBand.Sort = new string[] {"ASC","Clients.Date"};
}

Any thoughts ??

Hello,

Should be:
DataBand.Sort = new string[] {"ASC","Name"};
}else{
DataBand.Sort = new string[] {"ASC","Date"};
}

Thank you.

Hi Lech !! Thanks for replying, I tried and still not working, the order is not applied to the data band. I even tried just the expression below to check and it didn't work.

DataInfoAlumnoBr.Sort = new string[] {"ASC","Nombre"};

Also, I'm getting the error below:

Hello,

Due to the error, you try to compare different types - DateTime and Integer.
Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Here are the sample report and data.

Hello,

Column FechaIncorporacionCentro is DateTime, should be:
if (InfoAlumnoBr.FechaIncorporacionCentro <= DateSerial(2019,01,03)){
...

Thank you.

Hi Lech !! thanks for replying, the error is gone but the expression still not ordering the results.

if(InfoAlumnoBr.FechaIncorporacionCentro <= DateSerial(2019,01,03)){
DataInfoAlumnoBr.Sort = new string[] {"ASC","Nombre"};
}else{
DataInfoAlumnoBr.Sort = new string[] {"ASC","FechaIncorporacionCentro"};
}

Hello,

The logic of that code is wrong. You try to change sorting for each row of that data. Which value should be used in that expression:
InfoAlumnoBr.FechaIncorporacionCentro <= 01/03/2019

Thank you.