Creating reports and dashboards | Stimulsoft community forum

Hi

When I used variables, I found that I couldn't sort the data columns.

For example, When I create a variable which I can select id(keys) and member(values), it goes:
Name: IDNum
Alias: Select a member
Type: string / List
Request form User
Data Columns
Keys: DataSource.id
Values: DataSource.member

Then, When previewing my report, the list of member goes: CCC, AAA, EEE, BBB...(This is the order in data source)
But "not" AAA, BBB , CCC, EEE, ....(The order I want)

How can I let data columns or variables go in alphabetical order?

Hello.

Unfortunately, there is no option to sort this list.
The order is taken from the Data Source.
If you use SQL Data Sources you could try to sort data in your SQL query.

Thank you.

@HighAley;

Is this still true/active?
Is it still impossible to sort the list in the dropdown for the user?

My SQL Data Source shows the data in the order 2, 4, 5 but in the report it's 2, 5, 4.

Hello,

We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.

Thank you.

In the last version of Stimulsoft Ultimate the problem still persists. I have an SQL datasource that order by a datetime column. In the dropdown the items are not respecting the order of the query. They only appear ordered when I click "show data" in the datasource editor. I am using the dropdown as a filter for the report.

Hello,

We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.

Thank you.

I have sent an e-mail to support@stimulsoft.com with the subject "Alphabetical order of data columns".

Thank you.

Hello,

Ok. We will check it and will reply by email.

Thank you.