KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Are SQL Views supported as datasources for a datastore? #1561

Open Richb201 opened this topic on on Aug 12, 2020 - 5 comments
Richb201 commented on Aug 12, 2020

I need to create a an excel worksheet with some calculated fields. The mySQL table doesn't exist. I can either do this with a View or I could create a Temporary table. Can either one of these two be piped into a datastore?

David Winterburn commented on Aug 13, 2020

Hi Richard,

Either a view or a temporary table can be piped to a datastore. Just use a select query with them like normal tables. Let us know if you have any problem. Thanks!

Richb201 commented on Aug 15, 2020

Thanks David. One more thing. I am looking at using a Stored Procedure. Will Koolreport work with stored procedures (in my SQL?).

David Winterburn commented on Aug 17, 2020

Please try to set your sql query to "Call StoreProcName" and see if it works. Thanks!

Richb201 commented on Aug 17, 2020

I haven't written it yet. When do you want me to call this? From within the SP or from the PHP?

David Winterburn commented on Aug 18, 2020

Please try to call it with the report's setup's query method in PHP. Thanks!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet
None

Designed and built with by KoolPHP Inc.

Code licensed MIT.