Export to Excel
Export to Excel
HY! I'm using Stimulsoft FX For PHP for 2 years now in various projects. Until now, all my reports were generated in PDF.
Now I need to export my data in Excel, but I can do that only as images?
I would like to export my formated data in excel report as data Is this possible with Reports.PHP 2015.1?
Thank you
Now I need to export my data in Excel, but I can do that only as images?
I would like to export my formated data in excel report as data Is this possible with Reports.PHP 2015.1?
Thank you
- Attachments
-
- Settings available
- 2_2016-11-04 08_33_31-ONTO.png (12.4 KiB) Viewed 6843 times
-
- ontoFinal.xls
- Generated XLS
- (1.81 MiB) Downloaded 296 times
-
- OntoFinal.mrt
- Report
- (111.21 KiB) Downloaded 320 times
Re: Export to Excel
Hello,
Please try to set the Allow HTML Tags property to false for Text components.
Also, please check the 2016.2 version, in which HTML tags will be exported as text.
Thank you.
Please try to set the Allow HTML Tags property to false for Text components.
Also, please check the 2016.2 version, in which HTML tags will be exported as text.
Thank you.
Re: Export to Excel
Thanks a lot.
Now it's working perfectly.
My next question is speed of the Data loading and report rendering as well as export time.
I have a report with around 500 pages (the same I attached) and the data loading + report rendering is around 2 minutes. Can it be shortened?
I'm not using cache, because it's even slower.
How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
Thank you for your answers!
Now it's working perfectly.
My next question is speed of the Data loading and report rendering as well as export time.
I have a report with around 500 pages (the same I attached) and the data loading + report rendering is around 2 minutes. Can it be shortened?
I'm not using cache, because it's even slower.
How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
Thank you for your answers!
Re: Export to Excel
Hello,
You can try to optimize your report:
https://www.stimulsoft.com/ru/blog/arti ... ng-reports
https://www.stimulsoft.com/ru/blog/arti ... rts-part-2
https://www.stimulsoft.com/ru/blog/arti ... rts-part-3
> How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
This error occurs only with this report or with any others?
Thank you.
You can try to optimize your report:
https://www.stimulsoft.com/ru/blog/arti ... ng-reports
https://www.stimulsoft.com/ru/blog/arti ... rts-part-2
https://www.stimulsoft.com/ru/blog/arti ... rts-part-3
> How to export that very report to xls? I'm trying, but when I click Save as Excel -> Ok...nothing happens?
This error occurs only with this report or with any others?
Thank you.
Re: Export to Excel
I have read that...and even after optimisation it's significantly slower than other report tools (based od .NET technology).
Regardless Export, I figure out that there is some kind of problem if too many page are selected for Export. If my report, for example, has <200 page, I can export it in 5-10 seconds. Is there some 'session timeout', so bigger report cannot be exported?
Regardless Export, I figure out that there is some kind of problem if too many page are selected for Export. If my report, for example, has <200 page, I can export it in 5-10 seconds. Is there some 'session timeout', so bigger report cannot be exported?
Re: Export to Excel
Hello,
Please check the last build. In one of the last version (after 2015.1) was fixed a problem with the flash player update.
Also, please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Please check the last build. In one of the last version (after 2015.1) was fixed a problem with the flash player update.
Also, please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Re: Export to Excel
Aleksey, thank you.
Now it works on localhost. However, if I try to load viewer / report on my webserver via remote access, it renders indefinitely?
Other reports works fine.
If you need that, I can set up my web server so will have 'live' access to report?
I'm sending you .mrt file in attachment.
Now it works on localhost. However, if I try to load viewer / report on my webserver via remote access, it renders indefinitely?
Other reports works fine.
If you need that, I can set up my web server so will have 'live' access to report?
I'm sending you .mrt file in attachment.
- Attachments
-
- ontoFinal2.mrt
- (93.91 KiB) Downloaded 293 times
Re: Export to Excel
Hello,
Please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Please send us your rendered report (.mdc file) which rendering more than 2 minutes for analysis.
Thank you.
Re: Export to Excel
Aleksey, thank you for your reply.
You can find report attached.
Also, you can check that report with live data on following link:
http://onto.smart-step.hr/stimulsoft/in ... ¶m1=15
(useful params: 10 or 15)
You can find report attached.
Also, you can check that report with live data on following link:
http://onto.smart-step.hr/stimulsoft/in ... ¶m1=15
(useful params: 10 or 15)
- Attachments
-
- ontoFinal2.mrt
- (93.91 KiB) Downloaded 355 times
Re: Export to Excel
Hello,
You send the report template again.
Could you save your rendered report and send us a .mdc file for analysis:
Thank you.
You send the report template again.
Could you save your rendered report and send us a .mdc file for analysis:
Code: Select all
report.Load();
report.Render(false);
report.SaveDocument("report.mdc");