Facing some issues in dashboard implementation

Giri Rajan commented on Dec 30, 2022

Hi Kool Report Team, We require assistance with dashboard implementation.

We follow the instructions in the Kool report dashboard documentation to integrate the dashboard into our application, but some problems arise.

An error message appears when you click the dashboard menu.

The koolreport method is not supported for route POST. Supported methods: GET, HEAD.

Sebastian Morales commented on Dec 30, 2022

I think you must enable POST method for the route to koolreport in your Laravel project for it to work. Rgds,

Giri Rajan commented on Dec 30, 2022

Hi Kool Report Team, Thanks for the reply.

We attempted the post method but received error message is.

The koolreport method is not supported for route GET. Supported methods: POST.

Sebastian Morales commented on Dec 30, 2022

Pls enable GET method for the koolreport route as well.

Giri Rajan commented on Jan 2, 2023

Hi Kool Report Team, Thanks for the reply.

I am trying to use the Koolreports dashboard with Laravel 9.4. I have followed the quick start guide, but I get the error "The application encountered an unexpected condition that prevented it from fulfilling your request."

Any suggestions?

KoolReport commented on Jan 3, 2023

Please turn on debugMode of Dashboard so that you know what went wrong.

class App extends Application
{
    protected function onCreated()
    {
         $this->debugMode(true);
    }
}

Giri Rajan commented on Jan 5, 2023

Hi Kool Report Team, Thanks for the reply.

When I try to put the table name in AutoMaker

 protected function dataSource()
    {
        return AutoMaker::table("Users");
    }

This error will occur.

Sebastian Morales commented on Jan 6, 2023

Since you are using PDO for MS SQL Server pls remove "charset" from your datasource setting so that the "SET names <charset>" command doesn't execute:

        return [
            "connectionString"=>...,
            "username"=>...,
            "password"=>...,
            // "charset"=>"utf8" // comment out or remove this line
        ];

Giri Rajan commented on Jan 6, 2023

Hi Kool Report Team, Thanks for the reply.

Normal table is working fine but if I add limit in table or add procedure to work it shows error

  public function dataSource()
    {
        // return AutoMaker::table("Users")->limit(10);
        return AutoMaker::procedure()->call("Exec [procedure] 'parm1', 'parm2','parm3',parm4");
    }

Sebastian Morales commented on Jan 9, 2023

Pls post your AutoMaker setup code. In case you use PDO for SQL Server database, AutoMaker class should extend \koolreport\dashboard\sources\SQLServer instead of \koolreport\dashboard\sources\MySQL.

KoolReport commented on Jan 9, 2023

Beside using the SQLServer class, the procedure call should be like this:

AutoMaker::procedure()->call("Name_Of_Procedure",["param1","param2"]);

Here is the documentation

KoolReport's Forum

Facing some issues in dashboard implementation #2923

Build Your Excellent Data Report