Access Modes
Running Reportico through the Reportico Package Controller
Reportico can be accessed in standalone mode ( i.e. not embedded in a page ) through the "Mode" controller to run reports. This allows you to access Reportico through the main Yii2 index.php so you can control user access. To access Reportico in admin mode with the Mode controller, use:
http://yii2_app_url/index.php/reportico/mode/admin
To directly access a Reportico project menu that you have created, use the menu mode and pass the project name in as a GET parameter:-
http://yii2_app_url/index.php/reportico/mode/menu&project=projectname
To directly access a Reportico project report that you have created in criteria entry (prepare) mode, specify the prepare mode and pass in the project and report xml file ..
http://yii2_app_url/index.php/reportico/mode/prepare&project=projectname&report=reportfile.xml
To directly execute a Reportico project report that you have created in criteria entry (prepare) mode, specify the prepare mode and pass in the project and report xml file ..
http://yii2_app_url/index.php/reportico/mode/execute&project=projectname&report=reportfile.xml
Passing Report Criteria Parameters within a URL
Each report designed in reportico can be created with custom user criteria selection. When running a report a user can use these criteria to filter the report data. You create criteria items within each report to allow the user to generate report output based on a selecteid date or date range, values selected from a lookup list or based on a text field. Each criteria item within a report has a name and values for a criteria item can be passed within a URL using the following format.
MANUAL_criterianame=value
For dates you provide
MANUAL_datecriterianame=yyyy-mm-dd
Note that for date values you can also specify special codes as well for example :- TODAY, YESTERDAY, FIRSTOFMONTH, LASTOFMONTH and more.
For date ranges you provide
MANUAL_criterianame_FROMDATE=yyyy-mm-dd MANUAL_criterianame_TODATE=yyyy-mm-dd
For lookup lists you can you user comma separated values
MANUAL_criterianame=value1,value2,value3So to generate a sales report for last month for products of type food or leisure you might run something like :-
http://yii2_app_url/index.php/reportico/mode/execute&project=projectname&report=reportfile.xml&MANUAL_daterange_FROMDATE=FIRSTOFLASTMONTH&MANUAL_daterange_TODATE=LASTOFLASTMONTH&MANUAL_category=Food,Leisure
Selecting Output format
You can run report output directly to HTML, PDF, CSV, XML or JSON passing any of these options to the target_format parameter. For example:-http://yii2_app_url/index.php/reportico/mode/execute&project=projectname&report=reportfile.xml&target_format=PDF
Passing the Project Password
If you have password protected you project then to access any reports from the command line, then you can add the URL parameterproject_password=password