Reportico for Yii2 allows you design reports which can be embedded or linked to within your Yii2 web site all accessed through a dedicated Yii2 controller.
The module allows you to :-
- embed reports into your web pages
- create links to reports
- create report projects against the default yii2 connection or against other databases defined in app/config/database.php
- use Reportico's default styling, or let it adapt to your site's bootstrap look and feel
- use the logged in user id as part of your report queries
Once installed you can take advantages of all the standard Reportico features such as :-
- Groups
- Charts ( Line, Bar, Area and Pie )
- Database driven criteria selection
- Assignments and expression using PHP
- the ability to plugin custom code
- Output in HTML, PDF and CSV
- Styling options
- Drilldown links
- Links to URLS
- Embedding Images
- Output in Sortable/Searchable Grid Format
- Ability to report by logged in user using the {FRAMEWORK_USER} tag .. and more ..
Requirements ¶
Yii 2.0
Usage ¶
Download and find out how to use the module here :- http://www.reportico.org/yii2/web/index.php/site/index
Example code to embed report output
$reportico = \Yii::$app->getModule('reportico');
$engine = $reportico->getReporticoEngine(); // Fetches reportico engine
$engine->access_mode = "REPORTOUTPUT"; // Allows access to report output only
$engine->initial_execute_mode = "EXECUTE"; // Just executes specified report
$engine->initial_project = "northwind"; // Name of report project folder
$engine->initial_report = "salestotals"; // Name of report to run
$engine->bootstrap_styles = "3"; // Set to "3" for bootstrap v3, "2" for V2 or false for no bootstrap
$engine->force_reportico_mini_maintains = true; // Often required
$engine->bootstrap_preloaded = true; // true if you dont need Reportico to load its own bootstrap
$engine->clear_reportico_session = true; // Normally required
$engine->execute();
Look like wonderful! thanks for share.
As title
Sound wonderful. Can you publish BSD licence? thx.
as title.
License
I have only GPL and commercial versions at the moment .. im not sure of the implications of BSD .. i will need to investigate.
Patch to fix installation error
Just to let anyone know who tried to download this and failed because it was prompting for a password that there is a fix mentioned here :-
[http://www.yiiframework.com/forum/index.php/topic/58193-yii2-reportico/](http://www.yiiframework.com/forum/index.php/topic/58193-yii2-reportico/ )
Alternatively I have fixed up the main package so you may be able to install via composer
error after install
I got an error when i set the admin password:
"Projects area does not exist - cannot write project"
Re: error after install
Hi there, this has happened to someone else, and im not sure why it happens..
but if you go in to the folder
II2APP\vendor\reportico\yii2-reportico\components\projects\admin\
and copy adminconfig.template to config.php and modify it to replace
SW_ADMIN_PASSWORD with an admin password of your choice and change
SW_LANGUAGE to en_gb it might work
See the reportico forum link for more details
Let me know here or on the forum if you have problems
Peter
Re: Re: error after install
It worked thanks.
Projects area does not exist - cannot write project
I got this error until I changed the following file:
vendor\reportico\yii2-reportico\components\reportico.php
Line 5468
From: $proj_parent = find_best_location_in_include_path($this->admin_projects_folder);
To: $proj_parent = $this->admin_projects_folder;
Something in the find_best_location_in_include_path() function in the swutil.php file does not like the path supplied and is returning nothing.
When I get some time I will debug more and let you know.
Not bad
Looks useful, however I find some a lttle "uncomfortable" to have to type a password if actually you have a RBAC system.
A question: is the URL "reportico" modifiable?
If you have any questions, please ask in the forum instead.
Signup or Login in order to comment.