Date column slowing reports
-
- Posts: 29
- Joined: Thu Jul 07, 2016 2:06 pm
Date column slowing reports
I have a simple list report with 2000 records working fine and takes about seconds to render!
But when I add a Date field (datetime nullable), the report become very slow to render, taking about 4 minutes to render.
I delete Date field and report works fine again. No sorting, no interaction, just a simple list.
If i change Date field from datetime nullable to datetime in the dictionary, reports works fine with the date field!
I took a look at debug output during rendering and I see the errors listed at the files attached.
But when I add a Date field (datetime nullable), the report become very slow to render, taking about 4 minutes to render.
I delete Date field and report works fine again. No sorting, no interaction, just a simple list.
If i change Date field from datetime nullable to datetime in the dictionary, reports works fine with the date field!
I took a look at debug output during rendering and I see the errors listed at the files attached.
- Attachments
-
- WithoutDateField.txt
- (603 Bytes) Downloaded 183 times
-
- WithDateField.txt
- (211.93 KiB) Downloaded 187 times
Re: Date column slowing reports
Hello.
Please, check if you set the type of the column to DateTime (nullable).
For some data sources could be the issue with parsing of date.
Please, try our latest build and if you still get the issue, please, send us your report template with sample data.
Thank you.
Please, check if you set the type of the column to DateTime (nullable).
For some data sources could be the issue with parsing of date.
Please, try our latest build and if you still get the issue, please, send us your report template with sample data.
Thank you.
-
- Posts: 29
- Joined: Thu Jul 07, 2016 2:06 pm
Re: Date column slowing reports
Hello,
Actually I had to set all columns from DateTime (nullable) to DateTime.
All my reports with DateTime columns are now rendering too much faster!!!
I think here is some problem setting DateTime(nullable) in the dictionary that is slowing reports to render.
But for me the problem is solved anyway!
Thanks!
Actually I had to set all columns from DateTime (nullable) to DateTime.
All my reports with DateTime columns are now rendering too much faster!!!
I think here is some problem setting DateTime(nullable) in the dictionary that is slowing reports to render.
But for me the problem is solved anyway!
Thanks!
Re: Date column slowing reports
Hello.
Could you send us your report template with sample data.
Please, describe in details how to reproduce the issue.
Thank you.
Could you send us your report template with sample data.
Please, describe in details how to reproduce the issue.
Thank you.
-
- Posts: 29
- Joined: Thu Jul 07, 2016 2:06 pm
Re: Date column slowing reports
I change data type for the correct types and worked fine! Thanks!
Re: Date column slowing reports
Hello.
Great!
Let us know if you need our help.
Thank you.
Great!
Let us know if you need our help.
Thank you.