SharedFunding:Report Designer
From Wiki
[edit] Introduction
The Openoffice.org Report Designer project aims is to create fast and powerful report editor for Tiny ERP, and other softwares. The basic goal behind that is any layman(non IT people) can easily create and modify reports for Tiny ERP. It will be integrate with Tiny ERP Server to simply add new fields, loops, expression ... Features Reports are designed under Openoffice.org and can be used from Tiny ERP without having installed Openoffice.org on the clients. The OOo plugins connect to Tiny ERP so that it allows you to add different objects from Tiny ERP:
- * Fields,
- * Loops on lists,
- * Languages,
- * Python Expression,
- * Images, etc.
It supports importing .RML file so that it is compatible with the old report system of Tiny ERP. It is also able to export files as .RML. The plugin works on most current versions of Open Office. The default behaviour is to produce .PDF in Tiny ERP according to selected documents. But the system is also able to create template of OpenOffice documents and automatically Tiny OOo when the user wants to edit documents with values within it. (like templates of Fax, Letters, ...) The OOo plugin connects into the Tiny ERP server using XML-RPC so that you can design your own report from any computer. The reports can be saved in the filesystem, like normal Tiny ERP report or in the database to be DB specific. Images are stored in the .RML so that you don't have to worry anymore about storing images.
[edit] Installation
Openoffice.org Report Designer plugin is very easy to install and use. The plugin is bundle of two files tinyreport.zip and Makefile. We have two types of installation procedure.
- Install using MAKE command
- Install using Extension Manager in Openoffice.org Write
[edit] Install using MAKE command
We have two attributes for MAKE command install attributes
- $ make install
- sh /usr/lib/openoffice/program/unopkg add v openreport.zip
- Raising process: file:///usr/lib/openoffice/program/soffice
- Arguments: nologo nodefault
accept=pipe,name=3ea0ece6402dd477e2833c1dc5f19e5e7eb912d2b4693074bebc9def277d6557;urp;
Ok. Connecting...Ok.
Copying: openreport.zip
Enabling: openreport.zip
Enabling: openERPReport.py
Enabling: Addons.xcu
unopkg done.
After installtion you will get Open Report Menu and its Toolbar in Openoffice.org Writer.
uninstall attributes
- $ make uninstall
- sh /usr/lib/openoffice/program/unopkg remove v openreport.zip
- Raising process: file:///usr/lib/openoffice/program/soffice
- Arguments: nologo nodefault
accept=pipe,name=7517cf84f0e01eb946e3e431dfd74e3d132516ba9c8a286c59a9ed5ebce46;urp;
Ok. Connecting...Ok. <br.
Disabling: openreport.zip
Disabling: Addons.xcu
Disabling: OpenERPReport.py
unopkg done.
[edit] Install using Extension Manager in Openoffice.org Writer
Installing by Extension Manager is interactive installation procedure, for installation you
have to use Tools -> Extension Manager provided by Openoffice.org Writer.
In Extension Manager you have Add button, by clicking add button you will get opendialog box from which you will have to select openreport.zip file.
After installtion you will get Open Report Menu and its Toolbar in Openoffice.org Writer.
[edit] Using Interface
[edit] Open Report Menu
- Above Figure displays Tiny Report Menu which will be available in Openoffice.org Writer
after installation of plugin.
[edit] Tiny Report Tool
[edit] Server Parameters
This Functionality is used to connect with Tiny ERP Server with different login mode. You can access that functionality by clicking on button on toolbar or just go to Tiny Report -> Server Parameters.
The screen will look like
After giving proper Server URL you can select Database available in selected server and then you can able to logged in as particular user.
By Clicking on 'Change' button
In Change button you can change your server, port by default Server is localhost and port 8069
[edit] Open a new report
You can open this dialog box by clicking on Tiny Report -> Open a new report
By using above window we are able to select module for that you want to create report.
This is first process to create new report you have to select module. By clicking on 'Use
Module in Report' selected module will be used to create report.
[edit] Add a loop
This functionality is used to create repeatIn statement in Tiny Report. You see this dialog
box by clicking on Tiny Report -> Add a loop from menubar or just 
clicking on
this button from toolbar.
After click on 'ok' button you will get repeatIn object just like displayed below
Above report statement is written in Input Field a special functionality available in Openoffice.org. In which main statement available in background and it will display some english type of name as here displayed |-.order.-|.
[edit] Add a field
This functionality is used to create field statement in Tiny Report. You see this dialog box
by clicking onTiny Report -> Add a field from menubar or just 
clicking on
this button from toolbar.
[edit] Add an expression
This functionality is used to create expression which we can not add by using fields in Tiny
Report. You see this dialog box by clicking on Tiny Report -> Add an expression from
menubar or just 
clicking on this button from toolbar.
After click on 'ok' button you will get expression object just like displayed below
[edit] Add Lang
[edit] Modify
This functionality is used to modify existing repeatIn, Fields, or Expression in Tiny Report.
This functionality will work with cursor you have to place your current cursor before the
report statement and it will open dialog box after detecting that that statement is weather
Expression, RepeatIn or Fields. You see this dialog by clicking on Tiny Report -> Modify
from menubar or just clicking 
on this button from toolbar.
Modify RepeatIn
- 'Place your cursor before report statement
After placing your cursor at the begining of the report statement press modify button from toolbar or click on Tiny Report -> Modify . it will detect the type of that statement weather its is Field, Expression or RepeatIn and generate window accordingly as displayed below give following window.
repeat statement
expression statement
[edit] Conversion Fields -> Brackets
The purpose of this functionality is mapping old (use bracket for writing report statement)
and new (use input filed for writing report statement). So whenever you want to convert
your new report statement to old fashion then you can use this method. if you want to
access this fuctionality you can click on Tiny Report -> Conversion Fields -> Bracket
from menubar 
or just click on this button.
Before Apply Conversion from Fields -> Brackets
After applying function you will get above report as under
[edit] Conversion Brackets -> Fields
This is reverse functionality in which you can change you old formated report into new
format. If you want to access this fuctionality you can click on Tiny Report -> Conversion
Bracket -> Fields from menubar or just click 
on this button.
After conversion has been applied we get below answer. If we have no value availabe in
database for Fields or repeatIns it will write TTT instead, same it will write ??????? at the
place of experession.
[edit] Export to RML
This functionality is used to generate rml from sxw. You Can access this tool from Tiny
Report -> Export to RML in menubar or by just clicking on this button from
toolbar.
The basic feature of this functionality is now you can create your rml file in just few mouse
clicks. The main requirements of this utility is you must have to save your report in Tiny
Server using Send to the Server functionality.
When you click on Export to RML It will open save file dialog box in which you can
specify file name and destination of rml file to save
[edit] Send to the Server
This is the most important functionality available in Tiny Report Design tools. The basic feature of this functionality is to add new report or update existing report to Tiny Server in RML as well as SXW format. You can access this feature by using clicking on Tiny Report -> Send to the Server in menubar
Above dialog box for new report and for existing report it will look like following dialog
[edit] Modify Existing Report
Openoffice.org Report Design tool provide functionality of modify existing report which is already available in tiny server. You can access this feature by using clicking on Tiny Report -> Modify Existing Report in menubar. By clicking on Modify Existing Report it will display dialog box displayed below
By clicking on Save to Temp Directory button you will get opened report in new writer
window as displayed below
[edit] About
The about window shows version and copyright information. You can access it from Tiny Report -> About in menu bar or by just clicking on this button on toolbar