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