On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote: > > Tom Davies wrote: > > Hi :) > > I have just done a bit of digging around. > > > > Looking back through Andreas' answers > > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80 > > > > I found this but i'm not sure it's much help for you > > http://nabble.documentfoundation.org/database-td3926217i20.html#a3928210 > > > > This one seems to expand on the useful line at the end there > > http://nabble.documentfoundation.org/Base-3-5-2-2-hangs-td3910280.html#a3911654 > > > > This one is a bit of an overview with nothing specific but might be useful > > to skim through for ideas > > http://nabble.documentfoundation.org/Address-Books-td3829696.html#a3832514 > > > > This one looks brilliant to me > > http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3819387 > > > > There is some documentation at > > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide > > and an FAQ (translated from the French team's) at > > https://wiki.documentfoundation.org/Faq > > > > Sadly most of the people that know a lot about the ins-and-outs of Base are > > unwilling to help write the Base guide so it's down to 1 person who is > > desperately busy with a lot of other projects. > >
Hi Tom Really - you seem to know a lot, are you writing a manual? @Girvin - there is no place that I've seen the report builder be that slow and not have an installation problem - not saying it is impossible but sounds really odd. 1500 records in a tabular report, 49 seconds is a long time for that actually. There is one exception to that, graphics - is your report including graphics stored in data fields? On the other hand Calc, as has been pointed out, might be your preferred path. Best, //drew > > > > > > > Tom, > Your "brilliant" link looks interesting. I knew Calc and Base have some > similarities internally, but I wasn't aware that my data could be > imported into Calc from my MySQL server. All of my reports are tabular > in format anyway, so Calc could be an option, if it could get my data. > One limit to using Calc would be Calc's row limit. I think I read that > LO just raised the maximum rows, but if there are more database records > than available Calc rows, then... > Can Calc be linked to a Base query to get its data? > If so, then all my sorting can be done in the query. I do not do any > grouping in my reports at this time. > > As an update to my problem with Report Builder, my 1500+ record database > takes 94 pages of a Report Builder / Writer document. I put on my > patience hat and timed how long it takes to format the report, ready for > printing. As a baseline, it takes about 49 minutes to create the > original document. I cleared my preferences and re-entered them, using > mostly defaults and timed it again: 49 minutes. So it is not preference > corruption from previous versions. I then updated my java to 1.6u30 and > timed it again: 49 minutes. So, it doesn't look like Java is the > problem. I then went back to my original use of SQL from when I created > the report with the wizard, rather than using a query for the data and > timed it: 49 minutes! No matter what I do, it takes about the same > excruciatingly long time to build my report. What is really frustrating > is that there is no status popup to inform me of what it is doing. It > just goes out to lunch. Actually, it seems to initially create 128 > pages with header and footer, but no data, at the end of the first > "sleep". When the page status at the bottom of the writer window drops > to 94 pages, I know it is done. Every so many pages, it does come back > alive for a second or two and then goes out to lunch again for several > minutes. Each time it returns, a few more pages are populated with data. > Girvin > > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
