Sort on date does not work in web browser
Posted: Wed Oct 12, 2016 9:53 am
I am using Report JS and the JS- and Wpf designer.
I have the following report design:
- Groupheaderband with condition on a numeric datasource column, 'JournalEntryLineJournalEntryNumberNumeric' in the example data below
- Databand with sorting on a date-type datasource column, 'JournalEntryLineFinancialDate' in the example data below
When this report is presented by use of Reports.JS in a web browser the sorting on date does not work as it should. The records in a group seems to be sorted randomly.
In the preview in the JS-designer the sorting on date is working successfully.
I have tried to sort on other column types then date, such as numeric column type, and this is working fine.
For your information I also include an example of the datasource:
{
"JournalEntryLineJournalEntryNumber": "4-2016",
"JournalEntryLineJournalEntryNumberNumeric": 4,
"JournalEntryLineFinancialDate": "2016-01-21T00:00:00Z",
"JournalEntryLineDescription": "®utg.mva",
"JournalEntryLineSubAccountID": null,
"JournalEntryLineAmount": -1800000,
"JournalEntryLineOriginalReferencePostID": null,
"AccountAccountNumber": 2701,
"AccountAccountName": "Utgående merverdiavgift, høy sats",
"SubAccountAccountName": null,
"ProjectProjectNumber": null,
"DepartmentDepartmentNumber": null
}
Best regards
Tor Kårstad
I have the following report design:
- Groupheaderband with condition on a numeric datasource column, 'JournalEntryLineJournalEntryNumberNumeric' in the example data below
- Databand with sorting on a date-type datasource column, 'JournalEntryLineFinancialDate' in the example data below
When this report is presented by use of Reports.JS in a web browser the sorting on date does not work as it should. The records in a group seems to be sorted randomly.
In the preview in the JS-designer the sorting on date is working successfully.
I have tried to sort on other column types then date, such as numeric column type, and this is working fine.
For your information I also include an example of the datasource:
{
"JournalEntryLineJournalEntryNumber": "4-2016",
"JournalEntryLineJournalEntryNumberNumeric": 4,
"JournalEntryLineFinancialDate": "2016-01-21T00:00:00Z",
"JournalEntryLineDescription": "®utg.mva",
"JournalEntryLineSubAccountID": null,
"JournalEntryLineAmount": -1800000,
"JournalEntryLineOriginalReferencePostID": null,
"AccountAccountNumber": 2701,
"AccountAccountName": "Utgående merverdiavgift, høy sats",
"SubAccountAccountName": null,
"ProjectProjectNumber": null,
"DepartmentDepartmentNumber": null
}
Best regards
Tor Kårstad