Large Reports

Stimulsoft Reports.PHP discussion
jppriest
Posts: 10
Joined: Tue Nov 13, 2012 7:29 pm

Large Reports

Post by jppriest »

Hi,

I have the Stimulsoft Reports.Fx for PHP option, but when I am producing a large report the flash player in the web browser hangs while it is rendering (the web browser informs the user it has become unresponsive and asks the use if they wish to kill the page / terminate the flash player). The actual data transfer from the server to the flash application doesn't take long, but the report that is generated has lots of bookmarks and is about 70 pages long.

How can I stop the flash player from hanging? Is there an option anywhere?

Thanks,
Jonathan.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Large Reports

Post by HighAley »

Hello.

Due a report is rendered in the Flex application and running time of a script is limited with 1 minute, the large amount of data could cause a freezing of the Flash player.
We made an improvement and the blank report will be shown now.

Thank you.
jppriest
Posts: 10
Joined: Tue Nov 13, 2012 7:29 pm

Re: Large Reports

Post by jppriest »

Will the rendered report eventually show?

Thanks.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Large Reports

Post by HighAley »

Hello.

The report will not be shown because the flash script can't be running more then 1 minute and it's not enough to build your report.

Thank you.
suyonob
Posts: 19
Joined: Mon Feb 18, 2013 6:42 am

Re: Large Reports

Post by suyonob »

Yes, I have same problem too...
so do you have solution to overcome above problem. i 'm trying to increase ClientRequestTimeout value inside config.xml file from 20 seconds to 2000 seconds. But there were stil problem.

Thank you.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Large Reports

Post by HighAley »

Hello.
suyonob wrote:Yes, I have same problem too...
so do you have solution to overcome above problem. i 'm trying to increase ClientRequestTimeout value inside config.xml file from 20 seconds to 2000 seconds. But there were stil problem.
How large is your report?

Thank you.
suyonob
Posts: 19
Joined: Mon Feb 18, 2013 6:42 am

Re: Large Reports

Post by suyonob »

I Have 128.557 Records from 1 table.
i will send *.mrt and *sql file, i'm used mariadb 5.3 instead.

please check my attachment...
May i know also how to make xml connection ?

it will be fun if i can using xml connection from postgresql, mssqlserver,firebird, etc.

Thank you

Suyono.
Attachments
my_report.mrt
(23.03 KiB) Downloaded 580 times
loket.7z
(1.27 MiB) Downloaded 374 times
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Large Reports

Post by HighAley »

Hello.
suyonob wrote:May i know also how to make xml connection ?
What do you mean under xml connection?

Thank you.
suyonob
Posts: 19
Joined: Mon Feb 18, 2013 6:42 am

Re: Large Reports

Post by suyonob »

I mean when i am watching video tutorial how to create connection. In video describe make a connection using xml file.
In air designer there were only mysql and xml option to make data source, so when i am going to postgre i have to create data source from web.

Please let me know ho to make xml file.
Thank you.

Suyon0
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Large Reports

Post by HighAley »

Hello.

This task is out of our competence. But you could find php script on the other sites. For example, PHP scripts for outputting a complete database table to xml (PostgreSQL and MySQL) or Transforming Results of PostgreSQL Query to XML, using PHP DOM

Thank you.
Post Reply