Hi Regina, et al I am working on a database for testing the functions listed in the OASIS document, amongst other things.
Darned if I know why I actually started with the function MOD..but I did. http://www.paintedfrogceramics.com/OpenOffice/QA/ReportDesigner/func_tests.odb What I will do is keep expanding this to include the functions defined in the OASIS document. ( I would hate to test functions that are not going to be supported...*smile* ) Also, the point that Regina made is very valid - assuming that what is intended here is that one created a function at the group level [ I don;t know that, but since it is there in the nav tree ] and then bind that to a formatted field in the group footer ( or header ) [ again I am extrapolating from what I see ] to get an aggregate is still going to be a pain. [ another assumption, that the functions are just as described in the document ] Because, if I want to sum up 4 columns I will need to create 4 individual functions FUNCTION_1 as SUM( [COL1] ) FUNCTION_2 as SUM( [COl2] ) FUNCTION_3 as SUM( [COl3] ) FUNCTION_4 as SUM( [COl4] ) Then drag and drop 4 unbound formatted fields in the group footer. Since I have to actually drag to create the frame for each they are not going to be the right size, or aligned...so then I will lasso them so that I can work with the alignment tools. Then I will have to select each one, go to the data page on the property page. Scroll to the bottom of the list of fields each time, since the functions are all displayed as [func_name] and therefore sort to the bottom of the list. Select the correct one. Then go back and do it again for the next three. There has got to be an easier way. Perhaps, if a column is dragged from the ADD FIELD window to a group footer or header that the application recognize this as an aggregate function candidate. In the property editor for that control there would then be a new property with a drop down for supported functions. ( sum, min, max, avg...whatever that list should be ). Perhaps there should be a way to create new functions at the group level and then these are also available in the drop down. These functions would take the column name from the bound column of the control they are used in. If that makes sense to you. Anyway, just a thought. Starting this work of reports to test the different functions has pointed out a couple of nice features in the designer. For instance. I have found that I can copy multiple controls from different bands in one report and paste them into a new report designer window. As long as the same number of bands exist in the new report the controls are placed in each as needed...very nice. Drew On 5/19/07, Regina Henschel <[EMAIL PROTECTED]> wrote:
HI, Ocke Janssen Sun Microsystems schrieb: > 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. I stuck at the same point. > [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). How can I do that? Is it the node "f(x) Function" in the Report Navigator? In the next row of the property browser you'll enter the > function [PopCount] + [Population] Does this mean, that I have to define my own SUM in a recursive way? 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 > Can give me a simple database document, where I can see a report with such a function, perhaps attach to issue 77604? kind regards Regina --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
