(Please click on the hexagons for more information)
This packages produces [LibreOffice Impress] (aka: PowerPoint) "reports" based on user-definable templates in Impress ODP format, that typically will show data in the corporate design. Typical use for this package are monthly project status reports that you want to share with different stakeholders. You can define multiple templates in order to vary the report details depending on the stakeholder, for example.
Reporting starts with a Impress ODP "template", which consists of a number of "slides". Each slide consists of:
Slides in OpenOffice Impress have a "name", which is part of the metadata of a slide. You can access the name by right-clicking a slide in the left "Slide Pane" and selecting "Rename Slide" in the context menu. The following slide types are currently available (in lowercase):
Gantt diagrams require multiple graphical elements in order to represent the various elements of a Gantt diagram:
These elements are defined in a "template" page and used by the "gantt" page when rendering the Gantt diagram.
Please see the elements of a sample "template" slide for reference
The following example is a PowerPoint report that lists all open projects in the system:
Related Packages
tcl/intranet-reporting-openoffice-procs.tcl
im_oo_cmd_executable_p Returns the path of the executable OpenOffice binary of "" if there is no such executable im_oo_page_delete Delete a list of pages im_oo_page_delete_templates Delete template nodes from the given page. im_oo_page_extract_templates Returns a key-value list of all "templates" on the specified page. im_oo_page_list "Execute" a list of pages. im_oo_page_notes Returns the "notes" from a slide page. im_oo_page_type_constant A "constant" page contains only static contents. im_oo_page_type_gantt Takes as input a page node from the template with a table and a sql parameter in the "notes". im_oo_page_type_gantt_grouping_extract_x_y_offset_list Takes a grouping, extracts all x and all y coordinates of objects and returns a list {min_x min_y}. im_oo_page_type_gantt_grouping_move Move all svg:x and svg:y coordinates in a grouping by the specified offset. im_oo_page_type_gantt_grouping_x_y_offset Takes a grouping, extracts all x and all y coordinates of objects and returns a list {min_x min_y}. im_oo_page_type_gantt_move_scale Move and scale a template bar according to start- and end date. im_oo_page_type_list Takes as input a page node from the template with a table and a sql parameter in the "notes". im_oo_page_type_repeat Repeat the following N slides for all rows coming out of the repeat_sql statement im_oo_page_type_static The procedure will replace the template's @varname@ variables by the values returned from the SQL statement. im_oo_page_type_template Takes as input a page node from the template with a list of templates on it. im_oo_select_nodes Returns a list of nodes that match the xpath. im_oo_substitute Returns a new tDom node with with a copy of $node with template expressions substituted. im_oo_substitute_descend Performes substitution on tDom nodes. im_oo_tdom_explore Returns a hierarchical representation of a tDom tree representing the content of an OOoo document in this case. im_oo_to_text Returns all text contained in the node and its children. im_oo_to_title Returns the title(s) of the node and its children.
sql/postgresql/intranet-reporting-openoffice-create.sql sql/postgresql/intranet-reporting-openoffice-drop.sql
www/ | |
index.vuh | |
report-list.adp | |
report-list.tcl |
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com