Re: [dba-dev] New cws rptchart02 for testing purpose
Ariel Constenla-Haile wrote: Hi Ocke, Ocke Janssen escribió: Moin all, now it's time for 2nd release. I fixed all reported issues but may be there are more unknown inside. So please test this version also :-) It is build on a DEV300.m13 where can we download it? Moin Ariel, sorry I missed that :-) Same location as before. ftp://qa-upload.services.openoffice.org/ - oj Regards Ariel. -- Ocke Janssen Tel: +49 40 23646 661, x1 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: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Hi Ocke, Ocke Janssen escribió: Moin all, now it's time for 2nd release. I fixed all reported issues but may be there are more unknown inside. So please test this version also :-) It is build on a DEV300.m13 where can we download it? Regards Ariel. -- Ariel Constenla-Haile La Plata, Argentina [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.ArielConstenlaHaile.com.ar/ooo/ "Aus der Kriegsschule des Lebens - Was mich nicht umbringt, macht mich härter." Nietzsche Götzendämmerung, Sprüche und Pfeile, 8. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Moin all, now it's time for 2nd release. I fixed all reported issues but may be there are more unknown inside. So please test this version also :-) It is build on a DEV300.m13 Best regards, Ocke PS: Thanks to issue submitter. -- Ocke Janssen Tel: +49 40 23646 661, x1 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: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Ocke Janssen wrote: Moin all, I uploaded a snapshot for the cws rptchart02 to ftp://qa-upload.services.openoffice.org/ To access it use your OOo account. There are English and a German version for Linux available and the new version of the sun-report-builder extension. This cws allows the user to insert a chart object into their report. The first column of a table/query/sql command is used as X-Axis for the chart. Unused columns can be deleted when double clicking the chart and open the context menu (right-mouse button) and select data ranges (2nd tab page) where you can remove unused ones. Happy testing. Best regards, Ocke PS: I believe that a lot more things need to be added to the wiki, like how do use charts in report. :-) A couple of thoughts. I can get it all looking quite nice in design mode - but runtime is a proving a bit different. Placing a graph in the detail section ( so that the whole report was the graph ) worked as expected with all the columns on the x axis displaying properly. Placed the graph in a group header and then linking the chart result set (RS) to the report's RS using the same fields as the group...seems right. When I link the result sets at design time I get what I expect in the x and y axis. I can bring up the chart properties editor and make changes and again it all appears correct. When I run the report the results are not coming in as I expect - some charts ( different group headers ) seem to to be missing data fields for instance. [ before I say that this is actually happening I need to go back and really scrub the queries I am using to be sure I am getting what I THINK should be there for each of the groups...) One thing that I do see - not sure how others will feel about this - the scale changes dynamically based on the data, now that sounds logical, but when the chart is in a group header then the data is related from one chart to another, and even though each group has, most likely, different range the overall range should be the same for all charts at that group level. For instance: Group 1 has a chart with a data range of 0 .. 61 Group 2 has a range of 1..20 Group 3 has a range of 20..70 I would prefer to have all three charts have a scale then of 0..70 ( or 100 ), but of course that is not what happens - so the relative size of the bars ( or sections ) in the different group charts is, well, not related. ( of course as I type this the idea dawns that maybe this can be set in the graph's property editor? ) Have not tried: multiple graphs in detail section / graph in report header or footer ...will try that tomorrow. Regarding an example - I was thinking of a Sneak Preview post at the forum...just as soon as I can figure out how to make a superscript TM without using html [ we don't allow html code in posts on the forum, so I will need to add the bbCode for it first, I would not want to violate the trade mark] ( twisted smirk...) Drew -- OpenOffice.org User Community Forum: http://user.services.openoffice.org United States PostgreSQL Association: http://www.postgresql.us/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Ocke Janssen wrote: Moin all, I uploaded a snapshot for the cws rptchart02 to ftp://qa-upload.services.openoffice.org/ To access it use your OOo account. There are English and a German version for Linux available and the new version of the sun-report-builder extension. This cws allows the user to insert a chart object into their report. The first column of a table/query/sql command is used as X-Axis for the chart. Unused columns can be deleted when double clicking the chart and open the context menu (right-mouse button) and select data ranges (2nd tab page) where you can remove unused ones. Happy testing. Best regards, Ocke PS: I believe that a lot more things need to be added to the wiki, like how do use charts in report. :-) A couple of thoughts. I can get it all looking quite nice in design mode - but runtime is a proving a bit different. Placing a graph in the detail section ( so that the whole report was the graph ) worked as expected with all the columns on the x axis displaying properly. Placed the graph in a group header and then linking the chart result set (RS) to the report's RS using the same fields as the group...seems right. When I link the result sets at design time I get what I expect in the x and y axis. I can bring up the chart properties editor and make changes and again it all appears correct. When I run the report the results are not coming in as I expect - some charts ( different group headers ) seem to to be missing data fields for instance. [ before I say that this is actually happening I need to go back and really scrub the queries I am using to be sure I am getting what I THINK should be there for each of the groups...) One thing that I do see - not sure how others will feel about this - the scale changes dynamically based on the data, now that sounds logical, but when the chart is in a group header then the data is related from one chart to another, and even though each group has, most likely, different range the overall range should be the same for all charts at that group level. For instance: Group 1 has a chart with a data range of 0 .. 61 Group 2 has a range of 1..20 Group 3 has a range of 20..70 I would prefer to have all three charts have a scale then of 0..70 ( or 100 ), but of course that is not what happens - so the relative size of the bars ( or sections ) in the different group charts is, well, not related. ( of course as I type this the idea dawns that maybe this can be set in the graph's property editor? ) Have not tried: multiple graphs in detail section / graph in report header or footer ...will try that tomorrow. Regarding an example - I was thinking of a Sneak Preview post at the forum...just as soon as I can figure out how to make a superscript TM without using html [ we don't allow html code in posts on the forum, so I will need to add the bbCode for it first, I would not want to violate the trade mark] ( twisted smirk...) Drew -- OpenOffice.org User Community Forum: http://user.services.openoffice.org United States PostgreSQL Association: http://www.postgresql.us/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Moin Zoltan, Reizinger Zoltán wrote: Ezzel a dátummal: Friday 09 May 2008 13.50.32 Ocke Janssen ezt írta: Moin all, I uploaded a snapshot for the cws rptchart02 to ftp://qa-upload.services.openoffice.org/ To access it use your OOo account. There are English and a German version for Linux available and the new version of the sun-report-builder extension. This cws allows the user to insert a chart object into their report. The first column of a table/query/sql command is used as X-Axis for the chart. Unused columns can be deleted when double clicking the chart and open the context menu (right-mouse button) and select data ranges (2nd tab page) where you can remove unused ones. Happy testing. I downloaded en version, installed on opensuse no problems, and I found some thing, if I report them in issue tracker, which labels I use? RPT chart in title? Please submit issues with RPT: in title. That should be enough. Created a new file. When I drag a new Chart into report, it shows in Report Navigator as Shape, if I insert a Graphic it has a Name Image Control in the Report Navigator, Yes, it should be Chart. First I put chart into detail area in report, and dragged into report footer, chart not shows data, but the links to table and data remains.Tried to edit by double clicking on chart caused crash. I'll have a look at it. But could you please submit an issue for this one with a sample report or short description. With a first try while writing this e-mail doesn't caused a crash. Thanks. Second In Chart Properties, General, Title not showing in chart, it is a desired thing or bug? Bug :-) It is the first try results, I will try it more. Thanks for testing. And how do like the feature chart in reports itself? Best regards, oj Zoltan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Ocke Janssen Tel: +49 40 23646 661, x1 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: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Ezzel a dátummal: Friday 09 May 2008 13.50.32 Ocke Janssen ezt írta: > Moin all, > > I uploaded a snapshot for the cws rptchart02 to > ftp://qa-upload.services.openoffice.org/ > To access it use your OOo account. There are English and a German > version for Linux available and the new version of the > sun-report-builder extension. > This cws allows the user to insert a chart object into their report. The > first column of a table/query/sql command is used as X-Axis for the > chart. Unused columns can be deleted when double clicking the chart and > open the context menu (right-mouse button) and select data ranges (2nd > tab page) where you can remove unused ones. > > Happy testing. I downloaded en version, installed on opensuse no problems, and I found some thing, if I report them in issue tracker, which labels I use? RPT chart in title? Created a new file. When I drag a new Chart into report, it shows in Report Navigator as Shape, if I insert a Graphic it has a Name Image Control in the Report Navigator, First I put chart into detail area in report, and dragged into report footer, chart not shows data, but the links to table and data remains.Tried to edit by double clicking on chart caused crash. Second In Chart Properties, General, Title not showing in chart, it is a desired thing or bug? It is the first try results, I will try it more. Zoltan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Hello, Mechtilde schrieb: > Hello Ocke, *, > > Ocke Janssen schrieb: >> Moin all, >> I complete my further post >> I uploaded a snapshot for the cws rptchart02 to >> ftp://qa-upload.services.openoffice.org/ >> To access it use your OOo account. There are English and a German >> version for Linux available and the new version of the >> sun-report-builder extension. > > I will try it but I will need nearly 1 hour preparing for installation > on my Debian system. :( I saw that it base on an older DEV300 version. so there are many error messages if you install it via dpkg -i. So I hope I find a bit time to do it on weekend. Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dba-dev] New cws rptchart02 for testing purpose
Hello Ocke, *, Ocke Janssen schrieb: > Moin all, > > I uploaded a snapshot for the cws rptchart02 to > ftp://qa-upload.services.openoffice.org/ > To access it use your OOo account. There are English and a German > version for Linux available and the new version of the > sun-report-builder extension. I will try it but I will need nearly 1 hour preparing for installation on my Debian system. :( Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-dev] New cws rptchart02 for testing purpose
Moin all, I uploaded a snapshot for the cws rptchart02 to ftp://qa-upload.services.openoffice.org/ To access it use your OOo account. There are English and a German version for Linux available and the new version of the sun-report-builder extension. This cws allows the user to insert a chart object into their report. The first column of a table/query/sql command is used as X-Axis for the chart. Unused columns can be deleted when double clicking the chart and open the context menu (right-mouse button) and select data ranges (2nd tab page) where you can remove unused ones. Happy testing. Best regards, Ocke PS: I believe that a lot more things need to be added to the wiki, like how do use charts in report. :-) -- Ocke Janssen Tel: +49 40 23646 661, x1 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: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]