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
Sort on date does not work in web browser
Re: Sort on date does not work in web browser
Hello, Tor.
Usually, we get such issues when there are some problems with parsing of the dates.
Could you send us your report template with sample data for analysis.
What version of the Reports.JS product do you use?
Thank you.
Usually, we get such issues when there are some problems with parsing of the dates.
Could you send us your report template with sample data for analysis.
What version of the Reports.JS product do you use?
Thank you.
Re: Sort on date does not work in web browser
Thanks for a fast reply. Attached you find the files required.
Designer version:
I am most of the time using the JS Report Designer version 2016.2.1. But I would prefer to use the Wpf version, since this seems more intiuitve/simpler to use and has newer features. But the Wpf version seems to struggle with handling the jason data for preview. But sometimes I use the Wpf Designer version 2016.2.2
Report JS version:
I guess this is the informasion you need:
/*
Stimulsoft.Reports.JS
Version: 2016.1.28
Build date: 2016.08.26
*/
Best Regards
Tor
Designer version:
I am most of the time using the JS Report Designer version 2016.2.1. But I would prefer to use the Wpf version, since this seems more intiuitve/simpler to use and has newer features. But the Wpf version seems to struggle with handling the jason data for preview. But sometimes I use the Wpf Designer version 2016.2.2
Report JS version:
I guess this is the informasion you need:
/*
Stimulsoft.Reports.JS
Version: 2016.1.28
Build date: 2016.08.26
*/
Best Regards
Tor
- Attachments
-
- PostingJournal.txt
- Jason formatted data file. I had to make the file extention 'txt' since I was not accepted to upload a 'json' type of file.
- (35.68 KiB) Downloaded 226 times
-
- PostingJournal.mrt
- (65.31 KiB) Downloaded 247 times
Re: Sort on date does not work in web browser
Hello,
We couldn't reproduce this bug. Please try to check the last prerelease build 2016.2.2 from 2016.10.07.
Thank you.
We couldn't reproduce this bug. Please try to check the last prerelease build 2016.2.2 from 2016.10.07.
Thank you.
- Attachments
-
- Capture.PNG (108.15 KiB) Viewed 2812 times
Re: Sort on date does not work in web browser
We are now running the latest Version With the same problem.
Version:
/*
Stimulsoft.Reports.JS
Version: 2016.2.3
Build date: 2016.10.14
*/
Regards
Tor Kårstad
Version:
/*
Stimulsoft.Reports.JS
Version: 2016.2.3
Build date: 2016.10.14
*/
Regards
Tor Kårstad
Re: Sort on date does not work in web browser
Hello,
Could you send us a screenshot and rendered report (.mdc file) which show the issue for analysis.
Thank you.
Could you send us a screenshot and rendered report (.mdc file) which show the issue for analysis.
Thank you.