Page 1 of 1

Date column slowing reports

Posted: Fri Jul 08, 2016 1:15 pm
by edsonmiranda
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.

Re: Date column slowing reports

Posted: Mon Jul 11, 2016 7:38 am
by HighAley
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.

Re: Date column slowing reports

Posted: Wed Jul 13, 2016 12:55 pm
by edsonmiranda
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!

Re: Date column slowing reports

Posted: Wed Jul 13, 2016 4:05 pm
by HighAley
Hello.

Could you send us your report template with sample data.
Please, describe in details how to reproduce the issue.

Thank you.

Re: Date column slowing reports

Posted: Fri Sep 23, 2016 5:18 pm
by edsonmiranda
I change data type for the correct types and worked fine! Thanks!

Re: Date column slowing reports

Posted: Mon Sep 26, 2016 9:43 am
by HighAley
Hello.

Great!
Let us know if you need our help.

Thank you.