Sort on date does not work in web browser

Stimulsoft Reports.JS discussion
Post Reply
torro
Posts: 10
Joined: Tue Sep 27, 2016 7:24 am

Sort on date does not work in web browser

Post by torro »

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
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Sort on date does not work in web browser

Post by HighAley »

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.
torro
Posts: 10
Joined: Tue Sep 27, 2016 7:24 am

Re: Sort on date does not work in web browser

Post by torro »

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
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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Sort on date does not work in web browser

Post by Alex K. »

Hello,

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
Capture.PNG (108.15 KiB) Viewed 2812 times
torro
Posts: 10
Joined: Tue Sep 27, 2016 7:24 am

Re: Sort on date does not work in web browser

Post by torro »

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
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Sort on date does not work in web browser

Post by Alex K. »

Hello,

Could you send us a screenshot and rendered report (.mdc file) which show the issue for analysis.

Thank you.
Post Reply