Some questions

Edmund Andersson · Post by **Edmund Andersson** » Thu Feb 03, 2011 6:20 am

Hi guys!

I´ve downloaded the prerelease from 1 Februari but i`m still facing the same problem as before with dates in filters.

I can´t get it to work at all... I´ve done the same thing as in my post (25 January 2011 19:14:47) but I only get Server Time out or nothing at all.

If i only wont to have data from yesterday (2010-03-02), how should I apply the filter?

Best Regards

Edmund

Post by **Vladimir** » Thu Feb 03, 2011 8:52 am

Hello, Edmund

In the new version, you can combine and compare the date and time in expressions. For example:

Code: Select all

{halmstad_skiftdata.LogDt > DateSerial(2005, 01, 20) + TimeSerial(17, 00, 00) && halmstad_skiftdata.LogDt < DateSerial(2010, 08, 25) + TimeSerial(11, 30, 00)}

The functions formats are as follows:

Code: Select all

DateSerial(year, month, day)
TimeSerial(hours, minutes, seconds)

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Thu Feb 03, 2011 9:41 am

Thanks Vladimir for your reply.

But I still can't get the hang of it.

As you see in pictures below I add a expression with a timespan (I add the expression between {} but they dissapers when I close and open it again).

But I only get Timeout (the table holds about 300 000 rows, is that a problem?)

The connction

The expression

And the output (error)

Regards

Post by **Vladimir** » Fri Feb 04, 2011 1:50 am

Hello, Edmund

Please try increasing the timeout in the config.xml file, the default timeout is 15 seconds.

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Mon Feb 07, 2011 9:06 am

Thanks Vladimir..!

I´ve tried to raise the timeout to 60 seconds, but it still don’t work with the table with 300.000 rows but it works fine with a table holding a couple hundred rows.

How does the filter works really? Are the filter expression parsed and added into the SQL query or is the filter function applied on the client side?

The web browser sometimes chasses when previewing the report so if feels like it gets to much data from the database?!

Regards

tony.tomov · Post by **tony.tomov** » Mon Feb 07, 2011 3:49 pm

Hello,
I have investigated this behaviour in the time when this feature was introduced.
Also everything is done at client side. You can easy say this if you see the SQL log file.

The filtering is ok when the database query has relative not big data, but the report hang when we have more than 100k rows
I have mentioned this problem before some time, but it seems currently there is no solution.
(A intelligent paging like this http://web.stimulsoft.com/ would be great when used with PHP)

I have partial solution for this problem and will publish it after day or two.

Also see this post:
http://forum.stimulsoft.com/Default.aspx?g=posts&t=4161

Kind Regards
Tony

Post by **Vladimir** » Tue Feb 08, 2011 2:31 am

Hello, Edmund

Yes, most likely it is a timeout problem of the script execution, described in this post: http://forum.stimulsoft.com/Default.aspx?g=posts&t=4161

We will solve this problem, but cannot yet say how long time it takes this. Alternatively, you can previously filter data using the SQL query, because filtering in data bands goes on the client side with already loaded data.

Thank you.

Edmund Andersson · Post by **Edmund Andersson** » Tue Feb 08, 2011 3:29 am

Thanks Tony / Vladimir for both of your answers...

Would it be possible for you to add a filter to the SQL Datasource?
I know that I can change the SQL query (and make my filter there) but not all of my users knows SQL so it would be easier to have the expression field (just like in the databand).

But hey...I still love your product, It Rocks!! :biggrin:

Post by **Vladimir** » Tue Feb 08, 2011 7:00 am

Hello, Edmund

We will do optimization of the report generator after the release of version 2011.1, which is scheduled for March.

Thank you.