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 (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 (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.
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
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.