Testing trial - no data retrieves in web

[melaniee]

I am trying to test Stimulsoft php reports - I have created several reports and they work fine and retrieve the expected data - but when I run them in a web page I just get a blank page. If I run the web designer and use preview I get data but not when I call it using this code:

params["txt"] = row.getFieldValue("ReportFilenamePath");

window.open("reportdesigner/reports.php?report="+params["txt"]);
return false;

I am trying to incorporate Stimulsoft into our PHPRunner projects. This would be a huge help for us moving away from using a legacy program for reporting.

I am sure I am missing something simple but I have worked for 1 1/2 days now and am stumped. I have tried using mysql and also mssql.

[Lech Kulikowski]

Hello,

Please check samples at the following link:
https://github.com/stimulsoft/Samples-Reports.PHP

Thank you.

[melaniee]

Yes I have looked through them. I am still at a standstill. I use PHPRunner because it is low-code so I will admit I am somewhat at a loss. I got some help from a PHPRunner user who is successgully using Stimulsoft with their projects, but I think he is using an older version so his instructions don't quite match what I downloaded. I will continue to plug along and keep trying. Chatgpt has been a bit helpful but I think it too is helping based on an earlier version of Stimulsoft.

[Lech Kulikowski]

Hello,

You can also check the dev documentation:
https://www.stimulsoft.com/en/documenta ... or_php.htm

Thank you.

[melaniee]

Finally got it working - it was a matter of getting my PHP and data extensions all working. I was finally able to get it to all click by using an ODBC connection to my database. I think this is a good product and I look forward to using it to see if it will meet our needs. We are currently using Crystal reports server and besides the $$$$ it is overly complex as well. The one thing that it has that we use extensively though is reporting based on exception - we set up a report on a schedule say every 5 minutes and if there are no rows it doesn't send the report out - if there are rows it does send it out. Hopefully I can find a way to do similar with Stimulsoft.

[Lech Kulikowski]

Hello,

Thank you for the information.

[melaniee]

By the way, I plan on posting step by step what I did to get everything to work for other PHPRunner users. PHPRunner is an amazing product (low-code rapid development) but adding Stimulsoft reporting to our PHPRunner projects is a game changer. Using it with PHPrunner will make security of who can run which reports etc very easy.

[Lech Kulikowski]

Hello,

Thank you for sharing your experience with other users.