To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94127
Issue #|94127
Summary|RPT: entering a parametrized SQL as chart data source
|(unnecessarily) asks for parameters
Component|Database access
Version|OOo 3.0 RC2
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|SRB
Assigned to|oj
Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Sun Sep 21 21:03:05 +0000
2008 -------
- open the attached database document
- open the contained report for editing
- mark the chart object
- on the "Data" tab page of the property browser, change the "Content type"
property to "SQL command"
- for the "Content" property, enter
SELECT HOUR( "occurrences"."Zeit" ) AS "Stunde", SUM( "occurrences"."Anzahl" )
AS "sum" FROM { OJ "occurrences" AS "occurrences" LEFT OUTER JOIN "tage" AS
"tage" ON "occurrences"."TagID" = "tage"."ID" } WHERE MONTH( "tage"."Datum" ) =
:monat AND YEAR( "tage"."Datum" ) = :jahr GROUP BY HOUR( "occurrences"."Zeit" )
ORDER BY "Stunde" ASC
=> as soon as this property is written (by pressing Enter or otherwise leaving
the input field), a dialog pops up, asking the user for parameters.
This is actually wrong, as no actual values are needed at this time, but
(at most) the table structure. So there's no need to bother the user here
(and in fact, when you would do the same thing for the overall report,
the dialog is not opened, as expected)
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
