format_check_box_column 

 
          format_check_box_column(string $column)
This is one of the appearance customization methods supported in Smart Report Engine. It displays a certain column in your report as checkboxes! This method is meant to be helpful if you have a boolean, bit or tiny-int column in your MYSQL database for storing 0, 1 values or true, false values and you want to show this column in your report as checkboxes where checked means true or 1 and unchecked means 0 or false.
# This method is exclusive to the commercial edition and is not supported in the community edition .

# Parameters

Parameter Description
$columnThe name of the column that you wish to show as checkboxes in your report.

# Returns

This method returns the calling object, so it can be chained with other methods in the ‘ReportOptions’ class

# Code Example

 
           try{
$report = new ReportOptions(SRE_PUBLIC_REPORT);
$report->select_tables(array("items"))
               ->select_fields(array("id", "country", "list_price", "product_name","photo","rating","discontinued"))
               ->set_grouping(array("country"))
               ->format_country_flag_column ("country")
               ->format_rating_column("rating")
               ->format_prefix_text_to_column("list_price", "$")
               ->format_check_box_column("discontinued")
               ->format_image_column("photo");
        $engine = new CustomEngine($report);
        $report_path = $engine->create_report();
echo "Your report URL:" . $report_path;
} catch (Exception $ex) {
   echo 'Caught exception message:  '.  $ex->getMessage();
}

# See Also

set_style_name
set_records_per_page
set_layout
set_header
set_footer
format_suffix_text_to_column
format_rating_column
format_link_column
format_image_column
format_country_flag_column

# Related Post

Columns Customization Options Supported by Smart Report Engine