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] > >
