After installing the Reportico Joomla Extension Reportico is available to for configuration in the Joomla! administrator panel in the Components menu :-
Choose the "reportico" item to enter Reportico. On first installation, the following page appears. Here you need to set the report designer password. You will need to enter this password each time you enter admin mode. Later you can embed the designer in your web site should you want and this would be accessible via this password. If you ever forget the password it can be found in the reportico component folder in "projects/admin/config.php.
After setting a password, the following page appears, prompting you to login as admin using the password just entered :-
On logging in, the following menu appears:-
Click on the "Create A New Project" link in order to start reporting. From here we will create a report project configured with a database and then we will create a report in the project. When you click this you will see the following :-
For the purpose of this introduction, we are going to connect to the current Joomla Database (you can connect to another database i ) and report on page hits. So enter a project name of "webstats" (a project folder is created with name under the Reportico component area in the projects folder), a project title of "Web Stats" and set the Database Type to "Framework". The latter means we will connect to our Joomla database using the current Joomla connection settings. Finally press the "Go" button. You should see this :-
Now press the "Admin Page" button to return to the Admin page. Notice that we now have the opportunity to run our new project :-
Press the "go" button against the "Run Project Report suite" - you should see :-
Press the "Create Report" button and you will enter the report designer :-
As above, Set the Report Title and a description and make sure you press the "Ok" button on the right hand side. to make any change you have to press this button.
After pressing ok, you should see the title change. Then press the "Query Details" button to enter some SQL :-
Enter the query above and press the ok button. If you get the syntax wrong you should get an error. Note that the table mentioned here is in the joomla database and may have a different prefix than mentioned here.
After entry of the SQL, let's save the report:-
Against the report file box enter the name "hits.xml" - (the xml extension is required). You need to remember this for when you use the report in a web page.
Now press the "Run Report" button and you return the report :-
Press "Go" and the report should run :-
Now we've created and saved our report, let's add it in our web site .. to do this we need to create a new module based on the Reportico module in order to run our report. So from the admin extensions menu select the module manager option :-
In the module manager choose the new module option ..
select "Reportico" from the module type :-
You can then configure the added module :-
We will name this page "Web hits", set the position to "hits" so we can refer to it in an article, and set the "Start Mode" to "EXECUTE", so we run the report output directly in the page we embed this, and set the "Access Mode" to "Run Single Report Output", which means the page wont allow access to report menus or criteria entry modes. You need to set the project folder name and the report filename - webstats and hits.xml respectively. Then press the Save button.
Now we want to embed this in an article. So bring up an article for editing .. for example :-
Now you just need to use the loadposition option to load Reportico and include a reference to the position which you called "hits". You may also be able to use the loadmodule option with the mode "Web Hits" as parameter.
Now you should be able to show the article in your website, for example :-
Using the Reportico front end you can modify this report to include criteria entry, add groups and a graph.
This information is available in the main Reportico documentation, but please feel free to email the Reportico website with any queries.