Order by date

[rafael.custodio]

Hi everybody !! I´m in need of some help with my report. I have the table below and I need to get 2 things done:

Capturar.JPG (41.71 KiB) Viewed 2964 times

1 - For everyone where the admission date is prior to 01/03/2019 I have to order them by alphabetical order.
2 - For everyone else in need to order by the Admission date.
The catch is, I can't have this report separated by a line like when you have the data grouped.

[Lech Kulikowski]

Hello,

You can use two DataBand with same data and different Filter and Sorting. In first DataBand show all records prior to 01/03/2019, in second after 01/03/2019. For each DataBand you can add necessary sorting.

Thank you.

[rafael.custodio]

@Lech, thank you so much for replying. I did as you suggested but now I'm having new issues with the report. The Data is grouped together through an ID number in a GroupHeaderBand and the second DataBand is not respecting the parameters that I had set in the GroupHeaderBand. How should I proceed ??

Capturar.JPG (120.11 KiB) Viewed 2948 times

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[rafael.custodio]

@Lech, here are the data and report as asked.

Relação de Alunos OrdenacaoPallas.mrt

(52.11 KiB) Downloaded 142 times

Rela__o_de_Alunos_OrdenacaoPallas.zip

(4.94 MiB) Downloaded 118 times

[Lech Kulikowski]

Hello,

Thank you for the sample, we need some time to investigate the issue.

Thank you.

[rafael.custodio]

Ok @Lech, waiting for an answer.

[Lech Kulikowski]

Hello,

Please place your bands twice, each with necessary filter and sorting.

Thank you.

[rafael.custodio]

@lech, I tried to do like you suggested and it work partially.

I got this result from the first line of data band:

Capturar01.JPG (54.68 KiB) Viewed 2860 times

And got this from the second line of data band:

Capturar02.JPG (32.85 KiB) Viewed 2860 times

Actually I need the report to look like this:

Capturar03.JPG (63.36 KiB) Viewed 2860 times

These are the filters for the first data band:

Capturar04.JPG (33.54 KiB) Viewed 2860 times

Capturar05.JPG (36.2 KiB) Viewed 2860 times

These are the filters for the second data band:

Capturar06.JPG (29.5 KiB) Viewed 2860 times

Capturar07.JPG (35.84 KiB) Viewed 2860 times

[Lech Kulikowski]

Hello,

In that case, you should remove grouping.

Thank you.