Yii 2.0: yii2-reportico

The Reportico Yii2 module allows you run reports within your Yii2.0 app
8 followers

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();

Total 8 comments

#19864 report it
dustbin1_uk at 2016/05/21 09:37am
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.

#18749 report it
xtreem at 2014/12/26 03:14am
Re: Re: error after install

It worked thanks.

#18733 report it
Reportico at 2014/12/18 05:15pm
Re: error after install

I Got An Error When I Set The Admin Password: "Projects area does not exist - cannot write project"

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

#18730 report it
xtreem at 2014/12/18 01:05pm
error after install

I got an error when i set the admin password: "Projects area does not exist - cannot write project"

#18317 report it
Reportico at 2014/10/14 03:32pm
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/

Alternatively I have fixed up the main package so you may be able to install via composer

#18265 report it
Reportico at 2014/10/08 07:49am
License

I have only GPL and commercial versions at the moment .. im not sure of the implications of BSD .. i will need to investigate.

#18262 report it
Scott_Huang at 2014/10/08 06:23am
Sound wonderful. Can you publish BSD licence? thx.

as title.

#18259 report it
Scott_Huang at 2014/10/08 05:29am
Look like wonderful! thanks for share.

As title

Leave a comment

Please to leave your comment.

Create extension
Downloads
No downloadable files yet