Re: [dba-dev] New cws rptchart02 for testing purpose

2008-05-28 Thread Ocke Janssen

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

2008-05-28 Thread Ariel Constenla-Haile

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

2008-05-28 Thread Ocke Janssen

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

2008-05-12 Thread Drew Jensen

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

2008-05-12 Thread Drew Jensen

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

2008-05-12 Thread Ocke Janssen

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

2008-05-09 Thread Reizinger Zoltán
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

2008-05-09 Thread Mechtilde
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

2008-05-09 Thread Mechtilde
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

2008-05-09 Thread Ocke Janssen

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]