Smart Report Engine | Report Options

dynamic_filter_more

 
          dynamic_filter_more($table, $column)

This is one of the dynamic filters supported in the Smart Report Engine to filter your report by parameters entered by your end users. In other words, your end users can change the output of generated reports based on the parameter values they enter before previewing the reports. For example, using this type of filter you can easily create a performance report where each end user can set certain indicators.
This method should be used with a numeric, date, or DateTime column to get all records that are more than the parameter entered by each end user. Please note that you can combine multiple filters for the same report.

# This method is exclusive to the commercial edition and is not supported in the community edition .

# Note

This filter can be applied on numerical, date, time or datetime columns.

# Parameters

Parameter	Description
$table	The table to be filtered.
$column	The filter-by column (The column by which you want to filter the report).

# Returns

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

# Code Example

 
           use SRE\Engine\CustomEngine;
use SRE\Engine\ReportOptions;
require_once "sre_bootstrap.php"; //Make sure use the correct relative path to this file.
$report = new ReportOptions(SRE_PUBLIC_REPORT);
$report->select_tables(array("items"))
        ->select_all_fields()
        ->set_grouping("country")  
        
        ->dynamic_filter_more("items","units_in_stock");
          
$engine = new CustomEngine($report);
$report_path = $engine->create_report();
if ($report_path) {
    echo "Report created successfully! Your report URL: $report_path  ";
}