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
