alphabetical order of data columns
alphabetical order of data columns
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?
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?
Re: alphabetical order of data columns
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.
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.
- Erwin Janssen
- Posts: 9
- Joined: Tue Nov 20, 2018 3:48 pm
Re: alphabetical order of data columns
@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.
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.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: alphabetical order of data columns
Hello,
We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.
Thank you.
We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.
Thank you.
Re: alphabetical order of data columns
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.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: alphabetical order of data columns
Hello,
We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.
Thank you.
We couldn't reproduce this issue.
Please send us a sample report with test data for analysis.
Thank you.
Re: alphabetical order of data columns
I have sent an e-mail to support@stimulsoft.com with the subject "Alphabetical order of data columns".
Thank you.
Thank you.
-
- Posts: 6263
- Joined: Tue Mar 20, 2018 5:34 am
Re: alphabetical order of data columns
Hello,
Ok. We will check it and will reply by email.
Thank you.
Ok. We will check it and will reply by email.
Thank you.