format_country_flag_column

 
          format_country_flag_column(string $column)  
This is one of the appearance customization methods supported in Smart Report Engine. It displays small country flags beside their names! This method meant to be helpful if you have countries stored in a column in your MYSQL database and you want to show the flags of these countries besides their names in your report. This should look nice especially if you are grouping your report by country.
# This method is exclusive to the commercial edition and is not supported in the community edition .

# Parameters

Parameter Description
$columnThe name of the column in which you want to display country flags 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();
}