Graph generating problem with more than 100 Records

Sowmya commented on Jul 15, 2019

Hi KoolReport team,

I am Sowmya. I use "KoolReport Pro". I have data about around 300 Records, for all these records I want to display in chart. I used "Pie Chart, Column Chart, Line Chart", but no chart is displaying for me out put. For these type of Bulk data how can I show in graph format....

Please support me, I am the only KoolReport user in my organization.

    Thank You in advance...

David Winterburn commented on Jul 15, 2019

Hi Sowmya,

Please make sure your first column's metadata and data is of type "string" and the 2nd, 3rd and the rest columns' ones are of type "number".

Sowmya commented on Jul 15, 2019

Ya I mentioned like that only...

report.php:

->query("select CustId,CustName,Month,Year,SUM(InvValue) as InvoiceValue 
		from MonthWiseSalesSummeriesNew where Month=4 and InvValue!=0
		group by CustId,CustName,Month,Year
		order by CustId,CustName,Month,Year")

view.php:

"columns"=>array(
            "CustName",
            "InvoiceValue"=>array(
            "type"=>"number",
            "label"=>"InvoiceValue",
            "prefix"=>"₹"
          )
        ),

David Winterburn commented on Jul 15, 2019

Please try:

        "columns"=>array(
            "CustName" => array(
                "type" => "string"
            ),
            "InvoiceValue"=>array(
                "type"=>"number",
                "label"=>"InvoiceValue",
                "prefix"=>"₹"
              )
        ),

Sowmya commented on Jul 15, 2019

Ya I tried as you suggested... But no use...

 "columns"=>array(
            "CustName"=> array(
                "type" => "string"
            ),
            "InvoiceValue"=>array(
            "type"=>"number",
            "label"=>"InvoiceValue",
            "prefix"=>"₹"
          )
        ),

I sended my result output throgh email, support@koolreport.com and my ID is sowmya.g@icsoft.co.in

Please Please check it once....

KoolReport commented on Jul 15, 2019

Do you in somewhere use Cube process or Transpose process as I can see from your image that you sent us, your data is in wrong direction. You are supposed to have 2 columns in your data, first columns contains all the CustName and second column is the value. Currently I see that you have about 100 columns. Each column is for a customer name.

KoolReport's Forum

Graph generating problem with more than 100 Records #983

report.php:

view.php:

Build Your Excellent Data Report