Some questions

Stimulsoft Reports.PHP discussion
Edmund Andersson
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Some questions

Post by Edmund Andersson »

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

Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Some questions

Post by Vladimir »

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
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Some questions

Post by Edmund Andersson »

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
Image

The expression
Image

And the output (error)
Image

Regards
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Some questions

Post by Vladimir »

Hello, Edmund

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

Thank you.
Edmund Andersson
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Some questions

Post by Edmund Andersson »

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
Posts: 72
Joined: Mon Jun 07, 2010 2:39 am

Some questions

Post by tony.tomov »

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
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Some questions

Post by Vladimir »

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
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Some questions

Post by Edmund Andersson »

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:
Vladimir
Posts: 1462
Joined: Fri Apr 13, 2007 4:05 am
Location: Earth

Some questions

Post by Vladimir »

Hello, Edmund

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

Thank you.
Post Reply