#85 Customizable reports module

[Aramis]

The 'new' reports module provides the capability to define and display user specific reports. This version is a preliminary version. It has not been tested thoroughly. It is provided to the community to gather feedback and suggestions.

DO NOT USE FOR PRODUCTION.

Installation guide:
1. unzip the file
2. copy the reports folder under /modules directory in your DotProject installation.
3. go through the module installation process in System Admin.

Note that the installation creates 4 new tables in the DB: reports, report_fields, report_filters and report_access.

Note also that some options are disabled. These options will be included in future release.

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

New version of the module. Additional features include:
- capability to define filters on any fields;
- reports based on user information (assignment, project/task ownership, ...);
- results can be sorted in descending orders;

Note that the DB records format has been changed. You need to reinstall the module using Admin module functions in DotProject.
File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

New version of the module. Additional features include:
- capability to define filters on any fields;
- reports based on user information (assignment, project/task ownership, ...);
- results can be sorted in descending orders;

Note that the DB records format has been changed. You need to reinstall the module using Admin module functions in DotProject.
File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

Here is a new version again. It fixes some bugs and includes a new logic for generating queries that is more robust. Repotrs can use a new field named Last activity to display the most recent log date.
File Added: reports.zip

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

New version of the customized reports module. This new function adds the following features:
- display user allocated/assigned time per period (days, weeks or months depending on the selected date range)
- display custom fields

For those who have already installed the previous version, you need to upgrade the module (a new column is created in the reports table).
File Added: reports.zip

[Nobody/Anonymous]

Logged In: NO

Thanks man, this is a damn good module!

[magdelaine]

Logged In: YES
user_id=1582223
Originator: NO

Hi, I had recommended the use of dotProject for a class web project and the only way I could get the reports I needed was by using your module. IMHO, this module takes dotProject to a whole new level of usefulness and functionality. In short, it rocks!! And it should definitely be included in the default installation when the bugs are worked out.

Thank you!

[Aramis]

Programming notes - incl. methodology to extend the reports to add-on modules

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: DotProject Reports Module.doc

[Aramis]

Zipped SQL file - Report examples (tasklist, completed, overdue, tasklog, userallocatedhours)

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: reports_table.zip

[maddunr]

Logged In: YES
user_id=1044114
Originator: NO

Hi Aramis,

Thanks a ton for this module. It works like a charm. My first attempt with a couple of reports (packaged with reports_table.zip) generated a bunch of mysql errors. Later on, I figured out that was because of some undefined fields being called. For example, I don't use "cost code / billing code". I removed that field from the report and it worked fine. Just thought I'd pass this on as an FYI for others.

Thanks again!
V

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

This new version of the module is intended to correct the reported bugs. It adds a new feature : creating an Open Office XML document as a report. The generated file can be opened using Microsoft Word version 2003 or 2007.
File Added: actionitems.zip

[Aramis]

Customizable reports V1.0

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

File Added: reports.zip

[Nobody/Anonymous]

Logged In: NO

Thanks for this wonderful report tool!
I changed the csv function so it displays the description with the char return instead of displaying one compact bloc. Maybe this could be added as an option. Here is what I changed:
//alan
// function CdPcsv($nc, $char=';' ) {
function CdPcsv($nc, $char='";"' ) {
$this->lines = array();
$this->numline = 0;
$this->ncols = $nc;
$this->separator = $char ;
}

function dPcsvLine\( $newline \) \{
//alan
    //$out= '';
    $out= '"';
    // delete CR and LF
    //alan
    //$newline  = str\_replace\(array\("\r\n", "\r", "\n"\)," ",$newline\);
    $newline  = str\_replace\(array\("\r\n", "\r", "\n"\),"\n",$newline\);
    //alan next line was added
    $newline  = str\_replace\(array\('"'\),"\'",$newline\);
    /\*if \(is\_array\($newline\)\) \{
        $out = implode\( $this->separator, $newline\);
        $nsc = $this->ncols-\(count\($newline\)-1\);
    \}  else \{
        $out = $newline;
        $nsc = $this->ncols;
        \}
    $out.= $this->separator ;\*/
    if \(is\_array\($newline\)\) \{
        $out .= implode\( $this->separator, $newline\);
        $nsc = $this->ncols-\(count\($newline\)-1\);

    \}  else \{
        $out .= $newline;
        $nsc = $this->ncols;
        \}
    $out.= '";';
    while \( --$nsc > 0 \)
        $out .= ';';
        //$out .= $this->separator;
    $this->lines\[$this->numline\] = $out;
    $this->numline++;
    \}

Alex

[kabs]

Logged In: YES
user_id=1041778
Originator: NO

What version of dP is this module supposed to be experimented with? I tried it on the latest 2.1.1. Unzipped it got the folder reports_080419. Copied this to the modules folder, went to admin and installed and it reported module installed and the the tables are created in my DB. When I try to enable the module I get a "Module setup file could not be found" error. Checked in the reports_080419 folder and the setup file is there. What could be happening here?

[Nobody/Anonymous]

Logged In: NO

It should be compatible with dP V2.1.1. personaly, I use it with V2.1-RC2.
When you copy the unzipped folder under the modules folder, you need to rename the new folder as "reports" instead of "reports_80419", otherwise, it will break.

[kabs]

Logged In: YES
user_id=1041778
Originator: NO

Thanks for the tip. The folder rename did the trick and it is now working beautifully

[Dronch]

Logged In: YES
user_id=1656653
Originator: NO

How can made like this:

|Name1|Name2|Name3
------------------------
Date1 | Log | Log | Log
Date2 | Log | Log | Log
Date3 | Log | Log | Log

?

[Aramis]

Logged In: YES
user_id=1646540
Originator: YES

I'm afraid you cannot do that Dronch!
Basically, the reports are based on data lists queried from the database, not on complex data processing to create fancy tables!!
What you can do is a table like this :

Date1
Name1 Log
Name2 Log
Name3 Log
Date2
Name1 Log
Name3 Log

[Wendy Dau]

Logged In: YES
user_id=2150480
Originator: NO

Where can we download this file???

[Wendy Dau]

Logged In: YES
user_id=2150480
Originator: NO

Sorry, I found that it was at the bottom of this page...