Hi Peter,
I have updated the demo code to the latest svn. The ReportTemplate menu
entry is not used anymore, basically the menu entries are as follows:
Data Context: define the “data context” from which data will be extracted.
From an SQL perspective, this is the ‘from’ clause of an sql query. The
’join formula’ goes in the first part of the ‘where’ clause if it is
present, alternatively you can enter the joins explictely in the table
field. For instance 'customers join invoices on (invoices.customer_id =
customers.id)
Fields: where fields can be defined. Fields are defined by an sql formula,
which then goes into the ‘select’ part of the sql query
ReportDefinition: this is where we define the way fields gets organised in
the report. Each field can either be:
- H - header (not supported yet)
- X - one of the rows ‘dimensions’ of the report
- Y - one of the columns ‘dimensions’ of the report
- M - a measure. You need to specify an aggregation function
This is strongly inspired from the DataPilot feature of open office. If you
specify an aggregation function for a dimension, then a sub total will be
done on that dimension.
ReportTemplate: not used, as this feature is now provided in ERP Admin ->
document templates
To view reports: Go to an application which supports viewing reports, such
as AR->Invoices. Select ‘reports’. You can see all the reports related to AR
defined in the system. To view one, just select the view icon
Graphs: graphs do not work at this stage, however we have plans to integrate
the reporting engine with “open flash chart” to produce nice looking graphs
of all sorts.
Hi Raphaël
I had a short look at the demo and I like what I see! The next step will
be installing it on my computer and checking it more throughly.
In the demo
http://dev.mitija.com/blueerp/index.php?=&menuaction=reports.ui_template.browse&entity=reports.ReportTemplate
currently crashes when clicking “Add” with:
Database error: Invalid SQL: select id, name from reports_fields where
datacontext_id=’’ and measure=1
mysql Error: 1054 (Unknown column ‘name’ in ‘field list’)
I guess with a local installation I can easily track that problem (or
you already fixed that in the SVN anyway).
How far did you get with the charts? The report defined in the demo
seems to be programmed to draw a block chart, but it seems to end up
with a table. Of course I just might have done something wrong.
Regards
Peter
Raphael Alla schrieb:
Hi Peter,
I may suggest for your needs to look at the reporting module of
BlueErp (the svn version only). While it was developed for BlueErp
it’s by no way specific to BlueErp. It allows to create cross tables
of all sorts, including sub totals etc.
The reporting tool is made with 3 levels of expertise in mind:
- end user - the end user simply selects reports models, enters
parameters, and see the result
- report creators: the report creator arranged pre-defined fields
into report models for other to use
- report administrator - the report administrators defines which
tables will be used to create reports, how they link together, and
which fields will be available to the report creator
Please go from (3) to (1) when trying to create a report. As there is
no documentation please feel free to ask me questions. Things may be
clearer when looking at the demo: http://dev.mitija.com/blueerp (user:
guest password: demo),
Cheers
Raphaël
Hello
We are wanting to add some crm-functions into egw-modules. This
means,
of course, a reporting tool too. importexport looks interesting, but
I
get errors over errors when trying to use it... (syntax errors,
undefined functions, xml-errors). Is that a problem of Firefox? I
got
the feeling that I did not exactly understand how it works...
Well, but at the other hand it doesn't seem to be what a normal
customer
would call a "reporting tool". These people want to see charts in
all
colors and forms and they all compare it to crystal. Therefore
importexport most likely needs at least a fancy graphical output
function.
Do you know what the plans are? Did somebody even already integrate
a
reporting software - it may be the crystal tool too? Right now it
does
look like our budget might be high enough to integrate something
existing but I am not sure if it would be enough to develop it
from scratch.
Regards
Peter
--
mit freundlichen Grüssen
Peter Guhl
Win-Lux GmbH
Obere Schöntalstrasse 22
CH - 8406 Winterthur
Telefon: +41 (0)81 330 51 51
Mobil +41 (0)76 437 03 09
Fax: +41 (0)81 332 44 58
Mail: peter.guhl@win-lux.ch
Skype: p_guhl
Web: http://www.win-lux.ch
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
<mailto:eGroupWare-developers@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Raphael Alla
Mitija Australia
+61 4 15 678 576
+687 78 86 86
http://www.mitija.com
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
mit freundlichen Grüssen
Peter Guhl
Win-Lux GmbH
Obere Schöntalstrasse 22
CH - 8406 Winterthur
Telefon: +41 (0)81 330 51 51
Mobil +41 (0)76 437 03 09
Fax: +41 (0)81 332 44 58
Mail: peter.guhl@win-lux.ch
Skype: p_guhl
Web: http://www.win-lux.ch
******************* Vertraulichkeitserklärung ***********************
Diese Mitteilung resp. deren Beilagen können vertrauliche und/oder
persönliche Informationen enthalten, die einzig für den adressierten
Empfänger bestimmt sind. Jegliche Kenntnisnahme oder Weiterleitung durch
oder an Dritte ist untersagt. Wenn Sie nicht der adressierte Empfänger
sind,
nehmen Sie bitte Kontakt mit dem Absender der Nachricht auf und löschen
Sie alle Kopien. Vielen Dank.
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Register now and save $200. Hurry, offer ends at 11:59 p.m.,
Monday, April 7! Use priority code J8TLD2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Raphael Alla
Mitija Australia
+61 4 15 678 576
+687 78 86 86
http://www.mitija.com
