Page 1 of 1

Order by date

Posted: Mon Aug 12, 2019 2:24 pm
by 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
Capturar.JPG (41.71 KiB) Viewed 3517 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.

Re: Order by date

Posted: Tue Aug 13, 2019 7:10 am
by 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.

Re: Order by date

Posted: Tue Aug 13, 2019 1:37 pm
by 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
Capturar.JPG (120.11 KiB) Viewed 3501 times

Re: Order by date

Posted: Thu Aug 15, 2019 6:51 am
by Lech Kulikowski
Hello,

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

Thank you.

Re: Order by date

Posted: Thu Aug 15, 2019 12:34 pm
by rafael.custodio
@Lech, here are the data and report as asked.
Relação de Alunos OrdenacaoPallas.mrt
(52.11 KiB) Downloaded 188 times
Rela__o_de_Alunos_OrdenacaoPallas.zip
(4.94 MiB) Downloaded 183 times

Re: Order by date

Posted: Sat Aug 17, 2019 2:34 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: Order by date

Posted: Mon Aug 19, 2019 3:17 pm
by rafael.custodio
Ok @Lech, waiting for an answer.

Re: Order by date

Posted: Mon Aug 19, 2019 8:51 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: Order by date

Posted: Wed Aug 21, 2019 5:54 pm
by 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
Capturar01.JPG (54.68 KiB) Viewed 3413 times
And got this from the second line of data band:
Capturar02.JPG
Capturar02.JPG (32.85 KiB) Viewed 3413 times
Actually I need the report to look like this:
Capturar03.JPG
Capturar03.JPG (63.36 KiB) Viewed 3413 times
These are the filters for the first data band:
Capturar04.JPG
Capturar04.JPG (33.54 KiB) Viewed 3413 times
Capturar05.JPG
Capturar05.JPG (36.2 KiB) Viewed 3413 times
These are the filters for the second data band:
Capturar06.JPG
Capturar06.JPG (29.5 KiB) Viewed 3413 times
Capturar07.JPG
Capturar07.JPG (35.84 KiB) Viewed 3413 times

Re: Order by date

Posted: Mon Aug 26, 2019 7:26 am
by Lech Kulikowski
Hello,

In that case, you should remove grouping.

Thank you.