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 s...@pmgroup.be 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
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
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
[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
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
Re: [dba-dev] SRB not working with Queries
On Fri, Jan 16, 2009 at 11:22 AM, Fernand Vanrie s...@pmgroup.be 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
