never mind that...I see it is addressed int he document
On 5/18/07, Andrew Jensen <[EMAIL PROTECTED]> wrote:
Voila - there be functions in my report Question - Small, Medium or Large function group will be supported, per the OASIS document? On 5/18/07, Andrew Jensen <[EMAIL PROTECTED]> wrote: > > [virtual tail between legs] > > Thanks > > On 5/18/07, Ocke Janssen Sun Microsystems < [EMAIL PROTECTED]> wrote: > > > > > 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] > > > > >
