KoolReport's Forum

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

SQL SERVER Pivot Example #705

Closed Carlos Eduardo Luminatti opened this topic on on Feb 23, 2019 - 8 comments
Carlos Eduardo Luminatti commented on Feb 23, 2019

Hi how are you all ?

Are there some full example using a localhost DB to create a pivot table ?

Thanks

KoolReport commented on Feb 24, 2019

The most important is to succeed connecting to SQL Server, you may use PDO or SQLSRVDatasource to connect. We have both example in our examples site (under DataSources section).

Carlos Eduardo Luminatti commented on Feb 24, 2019

Hi, i solve this yesterday. TKS.

KoolReport commented on Feb 24, 2019

Great!

Carlos Eduardo Luminatti commented on Feb 24, 2019

But in this Topic, i want a complete example using this pivot table. Not parts separated, but one case with all that is need to run this pivot table. Tks

David Winterburn commented on Feb 25, 2019

Hi Carlos,

Would you please visit our examples for the Pivot package at this link: https://www.koolreport.com/examples/reports/pivot/years_months_customers_categories/

All the pivot examples are on the left side menu. You could check their source code in the below tabs in each example. Thanks!

Carlos Eduardo Luminatti commented on Feb 25, 2019

But i need a example of complete PHP script working .

Are there ?

KoolReport commented on Feb 25, 2019

Yes, you may find working example inside "examples" folder of koolreport_pro that you downloaded.

Carlos Eduardo Luminatti commented on Feb 25, 2019

TKS ! I Will test !

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
help needed
solved
None

Designed and built with by KoolPHP Inc.

Code licensed MIT.