View source | View content page | Page history | Printable version   

Projects:GenericTreeReport Functional Specification

Contents

Overview & Justification

Purpose

The purpose of this document is to describe the Functional Specifications for an extension module to be developed in OB ERP version 2.50 called Generic Tree Report.

Scope

Generic Tree Report is intended to provide a report that show the tree representation/hierarchical relationship among the records in a selected table.

Justification

User Goals

Functional Requirements

1. To create a report that renders the tree/hierarchical view among the records in a specified table.

Technical Requirements

In order to implement the functionality, the following high level technical requirements are needed.

1. Two different windows are to be new developed.
1.1 Generic Tree Report Setup window - The following fields are to be added in this window
      Report Name :    (Text Box has to be provided)
      Table       :    (Drop down box to be provided with all the table names)
      Parent ID Column      :    (Drop down box to be provided with all column names corresponding to the table we selected)
      Is Summary Column :    (Drop down box to be provided with all column names corresponding to the table we selected)
      Parent ID Column :    (Drop down box to be provided with all column names corresponding to the table we selected)
1.2 Generic Tree Report window - The following fields are to be added in this window along with "Print Report" button on toolbar.
      Report Name:    (Dropdown box populated with all report names created in Generic Tree Report Setup window.
     
2. Need to create a new table that holds all the tree reports.
3. Need to write a stored procedure that returns list of trees present in a table and takes the report id as input,
4. Based on the result from stored procedure, render the tree output using JRXML. (see the sample report at Assumptions section)

Assumptions & Dependencies

Assumptions

C_TAX
The following example shows the sample record set of C_TAX table.

tax_id name isSummary parent_tax_id
100001 VAT 16% + Withholding 20% Y -
100002 VAT 4% + Withholding 15% Y -
100003 VAT 16% N 100001
100004 VAT 4% N 100002
100005 Withholding 20% N 100001
100006 Withholding 15% Y 100002
100007 Withholding 10% N 100006
100008 Withholding 5% N 100006

And the Report should be rendered as depicted below.

VAT 16% + Withholding 20%
VAT 16%
Withholding 20%
VAT 4% + Withholding AB - 15%
VAT 4%
Withholding AB - 15%
Withholding A - 10%
Withholding B - 5%

Dependencies

User Interface Changes

New User Interface

Discussion items

Open discussion items

Closed discussion items

Appendix

Retrieved from "http://wiki.openbravo.com/wiki/Projects:GenericTreeReport_Functional_Specification"

This page has been accessed 1,393 times. This page was last modified on 8 June 2012, at 05:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.