Hi Andrew,
Andrew Jensen wrote:
I'll just jump into the questions, if you don't mind.
Functions:
[ ....... long description of what I tried deleted for you
convenience.......... ]
OK, I give up - how do you reference a data column in a function.
[ColumnName] :-)
For example you want to count something you have to create a new
function and give it a name let's say PopCount (to count the population
of a country). In the next row of the property browser you'll enter the
function [PopCount] + [Population] As you can see, all names are quoted
with []. The initial value in this case is [Population]. Population is
the field/column name out of my database. All formulas should follow the
style defined in OpenFormula
http://www.oasis-open.org/committees/download.php/23519/openformula-20070414.odt
For example creating an aggregate value for a group?
I have read ( good scan anyway ) through the Pentaho documentation
regarding
functions, is OOo's designer going to use the same approach?
New question.
API for new document type?
The new API can be found in com.sun.star.report.*
I have tried inspecting the report object to no avail.
Object Inspector doesn't work with any of the 2.3 builds.
I assume the IDL documents are not up to date on this yet, I have
looked and
there seems to be nothing about these reports specifically.
You have to look for it in the cws oj14.
Xray does work.
Looking at the ReportDefintion I can find nothing different using the
com.sun.star.sdb.DocumentDefinition service. In other words I can't
really
see how to know it is a designer report versus a wizard report or a form.
Reading the propertyset doesn't seem to help me.
When you execute the DocumentDefinition with the edit command, you'll
get a com.sun.star.report.ReportDefinition. This service is the model of
the report. From here on you can go every where in the report.
If I use Xray to look at the report after it has opened ( run ) I am
again
stumped.
Nothing, not even in the forms property of the drawpage property.
Yes, when you run it, you'll get a "general" text or spreadsheet
document without any hidden controls.
What will be exposed via an API of the report structure?
Specifically, I want to be able to set parameters in the report prior
to the
run - what is envisioned?
Yes, I can attach the report to a query, and I can manipulate the query
definition prior to running the report - that works just fine, but will
there be more?
Why not create a query with parameters? The report will ask for it when
executing. Or do you mean without user interaction?
I figure it is just my lack of skills...after all Ocke says I should
be able
to figure this all out without any documentation... *wink*...
So where are the issues ;-)
[ you had to know when you said "Currently there exists no
documentation, so
you have to find the way by yourself. But that should always be possible,
otherwise the GUI is wrong and we must fix it. :-)" in the Blog was gonna
come back to get you. ]
New Questions:
Report Title?
:-) Already known issue.
------------------- wow ------------------------------
I just realized I can generate a spread sheet...
Please submit issues when the output differs from the input.
Enough questions for now...I have new things to learn and test.
Drew
Ocke
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Marcel Schneider, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
