[libreoffice-users] Re: Base and new Report Builder in 3.5
Hi Andreas... I know it's been a while since you posted - I'm not sure if you have solved this problem yet. Anyway, this is what I found works for me using the LRD (legacy 'old' report designer/wizard) in LO 3.5.3 to create the report: STEPS 1. Create your primary SQL query showing all the fields contained in your report. This is the QUERY the report 'feeds off'. 2. In your query above, make sure the primary sort field/column (using the ORDER BY command in the SQL) is the one you are using for the GROUP header in the REPORT. If you don't do this, I found, like you, that the report GROUP HEADER text gets repeated, instead of occurring ONCE at the beginning of the GROUP as it should. Of course, you can also add secondary sorts as usual in your query. 3. When you first create your report in the LRD (not the Report Builder Extension), even though you will select the relevant query you created in step 1 above, you will probably need also to paste the SQL for this query (step 1 above) into the hidden COMMAND field in the report FORM NAVIGATOR window. This is due to the BUG mentioned elsewhere. See this: https://bugs.freedesktop.org/show_bug.cgi?id=47473 4. Hopefully, your report should now behave properly. 5. More info is here: http://en.libreofficeforum.org/node/2589 http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3835807 There is also info here about re-using legacy reports done in OO (or maybe early versions of LO). Let us know if this helps you. - Fred -- View this message in context: http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-tp3817159p3961330.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] Re: Base and new Report Builder in 3.5
On 3/12/2012 10:21 AM, Andreas Säger wrote: I prefer Calc as a simplified report engine. It supports more math functions than anything else. It provides the natural surrounding for charts. It supports dynamically linked, (conditionally) formattable import ranges, pivot tables, secondary filters and sort orders. It is the only report format which can be loaded from any form with a click on a simple hyperlink. HOWEVER . . . Calc is also broken in 3.5, in that you cannot filter any data from external sources, so it makes it virtually impossible to run reports in Calc in 3.5. -- Steven Shelton Deputy Undersecretary for Made-up Titles -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] Re: Base and new Report Builder in 3.5
Andreas , Am 11.03.2012 19:48, tops wrote: Hi all, I have been using OO and LibreOffice prior to 3.5 with Base and Reports. Now the Reports in 3.5 can not be used any further, instead I had to try (despair) and create new Reports using the Oracle Reports Tool. IMHO this is a major leap backwards… It is very, very slow on my Mac (2.13 GHz Core2Duo), it does somehow not save my new generates Reports. If I choose the Table Model it will write the Column Heading repeatedly (I did not find a way to prevent this) on each Row. To Adjust the Columns and Rows is REALLY Painful. It is no longer possible to use Fields i.e. Page Numbers. Despite setting the Format to A4 Landscape the GUI will limit placing Labels further than 200mm of a Portrait A4 Page. I prefer Calc as a simplified report engine. It supports more math functions than anything else. It provides the natural surrounding for charts. It supports dynamically linked, (conditionally) formattable import ranges, pivot tables, secondary filters and sort orders. It is the only report format which can be loaded from any form with a click on a simple hyperlink. All you have to take care of is the proper page layout. [Tutorial] Using registered datasources in Calc: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=18511 We came to the same conclusion: use Calc for reporting. We recently solved to export resultsets to calc (doimport) thanks to Villeroy :-) It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
[libreoffice-users] Re: Base and new Report Builder in 3.5
Am 13.03.2012 12:11, Fernand Vanrie wrote: It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand Page headers and footers can not have database content unless you write a macro. But even with a macro the header/footer content will be the same on every page. Of course you can have column headers and column footers with additional formulas. Grouping can be done by the database software (SELECT ... GROUP BY ... ORDER BY ...) or by a pivot table (aka data pilot). Pivot tables are database reports. They follow the exact same logic as a SELECT ... GROUP BY ... query. In addition, a pivot table can utilize the horizontal dimension by means of column fields. http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] Re: Base and new Report Builder in 3.5
Andreas , Thanks for your interest With grouping i meaned having the content of the grouped column on top or at the bottom off the items off the same group. We where thinking on a macro who use a resulstet to fill the spreadsheet cell by cell with some counters who are making a groupheader or footer when the content of a column changed to a different vallue. I look also a bit closer to the pivot tables Greetz Fernand Am 13.03.2012 12:11, Fernand Vanrie wrote: It would be handy to see some examples of how you make reports with calc. We have questions on how to Make headers , footers and grouping somes results ? Greetz Fernand Page headers and footers can not have database content unless you write a macro. But even with a macro the header/footer content will be the same on every page. Of course you can have column headers and column footers with additional formulas. Grouping can be done by the database software (SELECT ... GROUP BY ... ORDER BY ...) or by a pivot table (aka data pilot). Pivot tables are database reports. They follow the exact same logic as a SELECT ... GROUP BY ... query. In addition, a pivot table can utilize the horizontal dimension by means of column fields. http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
[libreoffice-users] Re: Base and new Report Builder in 3.5
Am 11.03.2012 19:48, tops wrote: Hi all, I have been using OO and LibreOffice prior to 3.5 with Base and Reports. Now the Reports in 3.5 can not be used any further, instead I had to try (despair) and create new Reports using the Oracle Reports Tool. IMHO this is a major leap backwards… It is very, very slow on my Mac (2.13 GHz Core2Duo), it does somehow not save my new generates Reports. If I choose the Table Model it will write the Column Heading repeatedly (I did not find a way to prevent this) on each Row. To Adjust the Columns and Rows is REALLY Painful. It is no longer possible to use Fields i.e. Page Numbers. Despite setting the Format to A4 Landscape the GUI will limit placing Labels further than 200mm of a Portrait A4 Page. I prefer Calc as a simplified report engine. It supports more math functions than anything else. It provides the natural surrounding for charts. It supports dynamically linked, (conditionally) formattable import ranges, pivot tables, secondary filters and sort orders. It is the only report format which can be loaded from any form with a click on a simple hyperlink. All you have to take care of is the proper page layout. [Tutorial] Using registered datasources in Calc: http://user.services.openoffice.org/en/forum/viewtopic.php?f=75t=18511 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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