Hi KoolReport team,

   I am Sowmya...I have data of more than 500 Records... To represent that data in Graph I used Donut Chart(For Monthly Report purpose) Cube Process to generate Line Chart(For Quarter Report of same data). I followed same process for all my reports... But one graph is not generated... Here I attached my code. Please Let me know what mistake I had Done....

ProductWise_OrderBooking.php

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

include APPPATH."\libraries\koolreport\core\autoload.php";

use \koolreport\KoolReport;
use \koolreport\processes\ColumnMeta;
use \koolreport\processes\Limit;
use \koolreport\processes\RemoveColumn;
use \koolreport\processes\OnlyColumn;
use \koolreport\processes\Sort;
use \koolreport\processes\Group;
use \koolreport\processes\TimeBucket;
use \koolreport\processes\Filter;
use \koolreport\processes\DateTimeFormat;
use \koolreport\processes\CopyColumn;
use \koolreport\processes\CalculatedColumn;
use \koolreport\cube\processes\Cube;

class ProductWise_OrderBooking extends \koolreport\KoolReport
{
	use \koolreport\codeigniter\Friendship;

	public function settings()
	{
		return array(
		"dataSources"=>array(
			"order"=>array(
				"connectionString"=>"sqlsrv:Server=SQLPC;Database=MainiDM",
				"username"=>"sa",
				"password"=>"sa1234",
				"charset"=>"utf8")));
	}
	public function setup()
	{
		$this->src('order')
		->query("select Prodid,ProdName,Month,Year,
					sum(orgvalue) as orderbooking
				from MonthWiseSalesSummeriesnew
				where Month=4 and orgvalue != 0
				group by Prodid,ProdName,Month,Year
				order by Prodid,ProdName,Month,Year")
		->pipe($this->dataStore("Apr_Order"));
    }
}

ProductWise_OrderBooking.view.php:

<?php
use \koolreport\chartjs\DonutChart;
use \koolreport\chartjs\AreaChart;
use \koolreport\chartjs\ColumnChart;
use \koolreport\chartjs\LineChart;

?>

<?php include(APPPATH."reports\mainiDM\head.php"); ?>
<br>
<h2 align="Center"> Product Wise Order Booking</h2>
<br>

<!-- <div class="row"> -->
	<!-- April -->
  <!-- <div class="col">  -->

<div class="card bg-light" style="margin-bottom:20px;">
<?php
DonutChart::create(array(
		"title"=>"April Bookings",
		"dataSource"=>$this->dataStore('Apr_Order'),
		"columns"=>array(
			"ProdName",
			"orderbooking"=>array(
				"type"=>"number",
				"thounsandSeparator"=>",",
				"label"=>"OrderValue",
				"prefix"=>"₹"
			)),
		"options"=>array(
			"title"=>"April Booking",
			),
		"width"=>'100%'


));

?>
</div>

index.php:

public function productWiseOrderBooking()
    {
      include APPPATH."reports\mainiDM\sales\orderBooking\ProductWise_OrderBooking.php";
      $report = new ProductWise_OrderBooking;
      $report->run()->render();

      }

From Home Page Menu item I am running this report....

<li><a href="<?php echo site_url('Home\productWiseOrderBooking'); ?>">Product Wise </a></li>

Through this type of code I got the graph for other datasources. This code only generates Grid report... My View is not loaded... Why it behaves like this I can't understand... Please Kindly Help me... Where I done mistake... I am using SQL Server.....

Thank You in advance...