Hello,
I hope I am in the right developer list ... I tried to use OOo Base as soon as it appeared, but I was always blocked with some problem. I discovered recently Sun Report Builder that solves many of them. Many thanks for this extension. This was what I was waiting for to move from Acces to OOo Base. To help developers enhance this extension, here is my SRB wishes / problems list : 1- Groups : ordering is not registered. I use Desc order and, each time the .odb is opened, the order must be reentered in report groups. This may be linked to the fact that the underlying query is/was in fact ordered in the opposite order (not sure, to be checked). 2- Fixed height : this is a problem for string field displaying memo fields that can contain 1 word or 1 million ! In Access, my report for 600 rows is under 30 pages, with SRB, it's more than double, and I some memo are not completely displayed. A dynamic height is mandatory for such field. 3- "Random" registering of modification. After having modified a property field, you must "quit" it before saving or running the report, otherwise, the modification may or may not be taken into account at the saving or running moment. Modification is not lost and will appear "later". 4- Adding a Labe / Data field in report is sometime impossible : this happens when you start the designing field with the mouse ON another one (whose limits are not clearly seen : label fields). SRB doen't want let you create the field but doesn't give any information. And it's not easy to exit from the design mode ... 5- SRB freeze : it happens from time to time ... difficult to know why. You can't close SRB, nor Base : you need to kill the process. 6- Through "report browser" (navigator ?), you can open / close report or page group. But if you close by error an existing report group (or page ?) and reopen it immediately, you have lost your job. A confirmation popup is mandatory ! 7- No user manual, no tuto. 8- Doc for function is unclear : 1st parameter always missing, no information on param types, no syntax, no example. 9- Report group is "under" page group. You can't remove 1st page header and having the report continue on 1st page : the 1st page contains only report header and 2nd page has following groups & details. 10- When running "long" reports, you may go & take a drink / meal ... It's long, very long (5 to 10 MS Access time). When the report appears, you can't use it before another long time. Page number starts at more than 2000 pages before decreasing to 50. At the moment, the report can be used, saved, ... 11- I did not find how to calculate the page number and total of pages : any idea ? (but I did not spend a long time on this) Anyway, the SRB is great and I will wait for enhancements, still using it even with its default ;-)) Thank you again for this OOo extension. Best regards Denis Note : For the french speaking (or at least reading !) people, I put a tuto here : http://user.services.openoffice.org/fr/forum/sutra56539.html#56539 This tuto is currently being enhanced. Informations will be given on this post in the french forum. Caution : a problem concerning Mod() function exists on Ubuntu Hardy and gives an error on some fields in exemple reports. (bug reported in ubuntu launchpad)
