Stimulsoft Business Intelligence System | Forum

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,

Hello,

Please explain your issue in more detail.

Thank you.

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,

Hello,

Could you provide test data for your report?

Thank you.

Dear all, good morning!

The report contains the query. But what data do you need in order to run the test?

Sincerely,

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.

Dear all, good afternoon!

Here is the example report.

Sincerely,

Hello,

The sent report without data.

Thank you.

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,

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.