Embed SQL Results Output

You can run report output without having to create a report. Just set the reportico project that relates to the database you want to run against (using the initial_project parameter) and use the initial_sql parameter to provide the SQL query. Note you cannot use the SELECT * notation in Reportico, you have to specify report columns.
Notice how column aliases in the SQL are used to set column titles.

    $engine = App::make("getReporticoEngine");
    $engine->initial_execute_mode = "EXECUTE";
    $engine->access_mode = "ONEREPORT";
    $engine->initial_sql = "SELECT CustomerID AS Id, companyname as company, contactname as contact_name FROM northwind_customers";
    $engine->initial_project = "northwind";
    $engine->initial_project_password = "password"; // If project password required
    $engine->set_attribute("ReportTitle","Customer List");
    $engine->clear_reportico_session = true;
    $engine->execute();

Note the use of the set_attribute function to set the report title. You can hide the report title instead using the call :-

$engine->output_template_parameters["show_hide_report_output_title"] = "hide";