Sorting Reports
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Sorting Reports
Dear all, good afternoon!
Is there a way to configure the report to display the data in ascending order?
We noticed that, in the attached report, the data coming from the database is organized in both ascending and descending order, but in the final report this ordering is not being reflected. We would like to ensure that the Report respects the specified ordering.
Atenciosamente,
Is there a way to configure the report to display the data in ascending order?
We noticed that, in the attached report, the data coming from the database is organized in both ascending and descending order, but in the final report this ordering is not being reflected. We would like to ensure that the Report respects the specified ordering.
Atenciosamente,
- Attachments
-
- CONSULTA AGENDAS_prueba.mrt
- (31.33 KiB) Downloaded 255 times
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sorting Reports
Hello,
Please explain your issue in more detail.
Thank you.
Please explain your issue in more detail.
Thank you.
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Sorting Reports
Dear all, good morning!
As mentioned earlier, the attached report has difficulties when trying to organize data by date, both ascending and descending.
By including the query in the data source and using the "order by dt_agenda asc" clause, for example, the expectation is that the data will be sorted ascendingly based on date. However, we noticed that the resulting sort is completely disordered.
I have therefore enlisted the assistance of the team to determine whether Report Designer offers any sorting alternatives that do not explicitly depend on "order by asc".
Sincerely,
As mentioned earlier, the attached report has difficulties when trying to organize data by date, both ascending and descending.
By including the query in the data source and using the "order by dt_agenda asc" clause, for example, the expectation is that the data will be sorted ascendingly based on date. However, we noticed that the resulting sort is completely disordered.
I have therefore enlisted the assistance of the team to determine whether Report Designer offers any sorting alternatives that do not explicitly depend on "order by asc".
Sincerely,
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sorting Reports
Hello,
Could you provide test data for your report?
Thank you.
Could you provide test data for your report?
Thank you.
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Sorting Reports
Dear all, good morning!
The report contains the query. But what data do you need in order to run the test?
Sincerely,
The report contains the query. But what data do you need in order to run the test?
Sincerely,
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sorting Reports
Hello,
This query to your database. We couldn't connect.
We need a sample report that we can run and reproduce the issue.
Thank you.
This query to your database. We couldn't connect.
We need a sample report that we can run and reproduce the issue.
Thank you.
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Sorting Reports
Dear all, good afternoon!
Here is the example report.
Sincerely,
Here is the example report.
Sincerely,
- Attachments
-
- Example.mrt
- (15.49 KiB) Downloaded 236 times
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sorting Reports
Hello,
The sent report without data.
Thank you.
The sent report without data.
Thank you.
-
- Posts: 53
- Joined: Mon May 30, 2022 7:35 pm
Re: Sorting Reports
Dear all, good morning!
What is this data? Because there is a query in the data source.
Do you want the results of the database query?
Sincerely,
What is this data? Because there is a query in the data source.
Do you want the results of the database query?
Sincerely,
-
- Posts: 6335
- Joined: Tue Mar 20, 2018 5:34 am
Re: Sorting Reports
Hello,
As a way, sql script for creating tables, and inserting several test rows. That allows us to run your report and reproduce the issue.
Thank you.
As a way, sql script for creating tables, and inserting several test rows. That allows us to run your report and reproduce the issue.
Thank you.