To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=96278
User r4zoli changed the following:
What |Old value |New value
================================================================================
Summary|Report not created |Report not created
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Nov 18 12:50:27 +0000
2008 -------
I tried again, on m35.
I created new file with connection to text file, and copied table form text
connected to new HSQLDB file, with copy wizard (similar as one attached to this
issue), and one field name (THRUST) created that it contain six extra spaces
after the word, I changed and no effect on this issue. (May be separate issue?)
I copied all data to MySQL database, and when copy wizards came up, where fileds
was text, on wizard it shown as memo, I changed to text, and created new report
and it runs well.
(If I copied report from HSQLDB to MySQL connected file, when report run, error
msg: The statement contains cyclic reference to one or more sub queries. It was
caused by changing table names, when you connect to MySQL)
It brings my attention to queries and SQL commands.
Back to HSQLDB file.
When I copied SQL commends from wizard generated report to Tools>SQL... the
command executed successfully, but when I tried to run report, hangs and gives
empty window.
Created a query with wizard, and it gives empty results set, If I run it in SQL
command it runs.
If I run similar on MySQL based file, it works well.
This issue not connected too much to report, it is more or less a query problem,
or database table copy issue or somithing else.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
