ALL s.c.r.l.

o- Installation
0. Install and Activate : Forena Reports http://drupal.org/projects/forena

1. Activate OCI in php  for ORACLE direct access
2. Config Data Access in Forena
    Configuration / Forena Reports / Data /
        Current User : None
        Data Security : Use Drupal Permissions
        Driver : Oracle Database
        uri : aullink
        user / password
3. Make the sql file : aullink/tblbrokers.sql    SELECT * FROM TBLBROKERS

4. Structure / Forena Reports / Create New report
    Report Name : ULLink Brokers [UAT]
    Name : aullink/brokers
    Category : ULLink

    a. Add Data    / aullink/tblbrokers
    b. Format Fields
    c. Make filter Parameters

o- RMK
    - Liste trop large
    - Filter Box : too tall & label on the same line as the text
    - Samples :  Project : Drupal Issues could be used as samples
                        Toodledo
                        MyWebForm : Form Survey : https://drupal.org/project/webform
                        Issue : https://drupal.org/project/project_issue
 

o- Kplus - ODBC

*- Data Connection
    PDO other than Drupal
    odbc:%DSN_Name%
    user:kplus
    password:%pwd%

*- Report definition
    Category : Can be a new one
    Name : Technical Name
    Title : User Title

*- Add Data to report
    Data Block : kplus/cwemir