Re: [dba-dev] SRB not working with Queries
Ocke , OK i reproduced the situation on a OO-native db But could not find the Issue I Filled this morning :-) joined to a native db file to issue *98245* and you will find 2 reports Report1 reporduce the non-Capitalized field name problem Report2 the bug mentioned in 98245 If you need a new isue for the non-Capitalized stuff, let me know I Greetz Fernand On 19.01.09 10:07, Fernand Vanrie wrote: Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) And a sample with hsqldb is not possible? - oj Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
On 19.01.09 10:07, Fernand Vanrie wrote: Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) And a sample with hsqldb is not possible? - oj Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Ocke Janssen wrote: Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Done: but cannot send a db file because you have no acces to or MSQL server :-) Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Andrew , Thanks for your extented reply, I know to make allias field names and yes thats the problem now the SBR works also with my query:. However is this a bug ? or is it a rule that we need capitalised FIELD NAMES ? Greetz Fernand On Fri, Jan 16, 2009 at 11:22 AM, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Hello Fernand, From your description I would suspect that the problem is with your column names in the result set. Try opening your query and ensure that you have created aliases for any returned column that uses a function. ie. SELECT AVERGE( "FIELD" ), COUNT( "FIELD") FROM "TABLE" GROUP BY "FIELD" Instead try: SELECT AVERGE( "FIELD" ) AS "AVG" , COUNT( "FIELD") AS "CNT" FROM "TABLE" GROUP BY "FIELD" Of course using the Query Designer you do this by adding the Alias in the cell just below the field selection. I would be surprised if this does not clear up your problems. HTH Drew - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Mechtilde, I use windows XP and the latest SBR 1.05 and i found the same behaviour for OO 2.41 and 3.0 . thanks for the reply Fernand Fernand Vanrie schrieb: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Which version of OpenOffice.org and of the SRB under which OS do you use? Regards Mechtilde - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
Moin Fernand, On 16.01.09 17:22, Fernand Vanrie wrote: I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Yes, please submit one and assign it to me. May be you add a sample db file that would simplify it a lot ;-) Best regards, Ocke Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org -- Ocke Janssen Tel: +49 40 23646 661, x1 Dipl. Inf(FH) Fax: +49 40 23646 550 Sun Microsystems Inc. Nagelsweg 55 mailto:ocke.jans...@sun.com 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: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
Re: [dba-dev] SRB not working with Queries
On Fri, Jan 16, 2009 at 11:22 AM, Fernand Vanrie wrote: > I am still strugling to get some simple Reports from a Base document with a > ODBC connection to a MSQL server > > To avoid format bugs (like timestamps etc...) i tried to prepare in OO a > query to run a report. Using this query to build a Report works OK but as > soon I use a simple grouping I run in a error when building the Report. > I suppose that SBR has troubles to intrepret the SQLor the fieldnames in > the OO-made-Query. > Then i made a view on the MSQL server and now the Report is build an Run > like a charm :-) > > Hello Fernand, >From your description I would suspect that the problem is with your column names in the result set. Try opening your query and ensure that you have created aliases for any returned column that uses a function. ie. SELECT AVERGE( "FIELD" ), COUNT( "FIELD") FROM "TABLE" GROUP BY "FIELD" Instead try: SELECT AVERGE( "FIELD" ) AS "AVG" , COUNT( "FIELD") AS "CNT" FROM "TABLE" GROUP BY "FIELD" Of course using the Query Designer you do this by adding the Alias in the cell just below the field selection. I would be surprised if this does not clear up your problems. HTH Drew
Re: [dba-dev] SRB not working with Queries
Fernand Vanrie schrieb: > I am still strugling to get some simple Reports from a Base document > with a ODBC connection to a MSQL server > > To avoid format bugs (like timestamps etc...) i tried to prepare in OO a > query to run a report. Using this query to build a Report works OK but > as soon I use a simple grouping I run in a error when building the Report. > I suppose that SBR has troubles to intrepret the SQLor the fieldnames in > the OO-made-Query. > Then i made a view on the MSQL server and now the Report is build an Run > like a charm :-) > > Is this behaviour as planned or is it a bug ? so yes where can i fill a > issue ? Which version of OpenOffice.org and of the SRB under which OS do you use? Regards Mechtilde -- Dipl. Ing. Mechtilde Stehmann ## http://de.openoffice.org ## Ansprechpartnerin für die deutschsprachige QA ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org
[dba-dev] SRB not working with Queries
I am still strugling to get some simple Reports from a Base document with a ODBC connection to a MSQL server To avoid format bugs (like timestamps etc...) i tried to prepare in OO a query to run a report. Using this query to build a Report works OK but as soon I use a simple grouping I run in a error when building the Report. I suppose that SBR has troubles to intrepret the SQLor the fieldnames in the OO-made-Query. Then i made a view on the MSQL server and now the Report is build an Run like a charm :-) Is this behaviour as planned or is it a bug ? so yes where can i fill a issue ? Greezt Fernand - To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org For additional commands, e-mail: dev-h...@dba.openoffice.org