Date column slowing reports

Stimulsoft Reports.WEB discussion
Post Reply
edsonmiranda
Posts: 29
Joined: Thu Jul 07, 2016 2:06 pm

Date column slowing reports

Post 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.
Attachments
WithoutDateField.txt
(603 Bytes) Downloaded 182 times
WithDateField.txt
(211.93 KiB) Downloaded 186 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Date column slowing reports

Post 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.
edsonmiranda
Posts: 29
Joined: Thu Jul 07, 2016 2:06 pm

Re: Date column slowing reports

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

Re: Date column slowing reports

Post by HighAley »

Hello.

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

Thank you.
edsonmiranda
Posts: 29
Joined: Thu Jul 07, 2016 2:06 pm

Re: Date column slowing reports

Post by edsonmiranda »

I change data type for the correct types and worked fine! Thanks!
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Date column slowing reports

Post by HighAley »

Hello.

Great!
Let us know if you need our help.

Thank you.
Post Reply