Order by date
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Order by date
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:
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.
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.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Order by date
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.
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.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: Order by date
@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 ??
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Order by date
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: Order by date
@Lech, here are the data and report as asked.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Order by date
Hello,
Thank you for the sample, we need some time to investigate the issue.
Thank you.
Thank you for the sample, we need some time to investigate the issue.
Thank you.
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: Order by date
Ok @Lech, waiting for an answer.
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Order by date
Hello,
Please place your bands twice, each with necessary filter and sorting.
Thank you.
Please place your bands twice, each with necessary filter and sorting.
Thank you.
- Attachments
-
- Annotation 2019-08-19 225047.jpg (224.91 KiB) Viewed 2873 times
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
Re: Order by date
@lech, I tried to do like you suggested and it work partially.
I got this result from the first line of data band:
And got this from the second line of data band:
Actually I need the report to look like this:
These are the filters for the first data band:
These are the filters for the second data band:
I got this result from the first line of data band:
And got this from the second line of data band:
Actually I need the report to look like this:
These are the filters for the first data band:
These are the filters for the second data band:
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Order by date
Hello,
In that case, you should remove grouping.
Thank you.
In that case, you should remove grouping.
Thank you.