Creating reports and dashboards | Stimulsoft community forum

Is it possible?

How?

Im trying "call sp_list()" but I get "Data not found"

Hello, Pier

Unfortunately, we have not tested work of the Reports.Fx for PHP with stored procedures. Please send us a sample of your database to support[at]stimulsoft.com with a link on this forum topic, we will try to find a solution for you.

Thank you.

Hi Vladimir

What we need is a way of letting the programmers change the MySQL queries, without having to open and save the report file everytime there's a little change.

Of course we are aware the result has to have the same columns.

Is there some way to do that dynamically for example with an external file?

Regards

Hello, Pier

You can check and change the SQL query in the following location: the handler.php file, sti_client_event_handler function, case "LoadData" section, $query variable.

Thank you.

Thanks Vladimir!

Ok, so I change the query in:
case "LoadData":
and
case "RetrieveColumns":

But how do I configure the data source in the designer? Do I leave the query field blank?

Hello, Pier

It does not matter. It is important for the designer and the viewer, what a response is received from the server.

Thank you.

Hi again Vladimir

I've tried putting the query in the handler.php and it worked. The problem is that I can't use procedures in that query. I suppose it's because your flash can't read the table column names.

Is there way to use mysql stored procedures?

I'm considering using an XML Webservice instead of stored procedures to separate data generation from the presentation. But that would be my second option...

TIA

Hello, Pier

Unfortunately, we have not tested work of the Reports.Fx for PHP with stored procedures. This task has already been added to our to-do list.

Thank you.

We'll try to find another solution then.

Thanks again

Ok!