To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=88450
Issue #|88450
Summary|Sun Report Writer version 1.0.2 doesn't handle queries
| with passed parameters
Component|Database access
Version|OOo 2.4.0
Platform|All
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|safway
------- Additional comments from [EMAIL PROTECTED] Fri Apr 18 18:45:22 +0000
2008 -------
Environment:
OO.o verion 2.4.0
Sun Report Writer version 1.0.2
Platform is Kubuntu Linux
Description:
After creating (and testing) a query that has a passed parameter, the Sun
Report Writer first displays the passed parameter correctly on the final report
and then a few seconds latter, changes the value of the passed parameter. The
passed parameter is of DATE format.
Steps to reproduce:
Ensure the Sun Report Writer version 1.0.2 extension is installed
Open Base
Create a table with the fields you want (see TableDesign attachment)
Select the "Queries" object icon
Create a query that has a passed parameter using any of the three tasks (Design
View, Wizard, or SQL View) provided. (see QueryWithParameter attachment)
<Test query to ensure that problem is not in query itself>
Once the query is created, right-click on it and select "Report..."
This opens up the Report Writer extension.
Add the fields you want including the parameter field (see
ReportWriterProperties and ReportWriterProperties2 attachments)
Save the report
Run the report (see QueryParameterPrompt attachment)
Looking at the passed parameter for one second, and it is correct, then it
changed its value AFTER it had been correct for about one second (see
ReportWriterOutput attachment)
By the way, Ocke Janssen, Thomas Morgner, and Pentaho teams, GREAT work.
---------------------------------------------------------------------
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]
