To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42722 Issue #:|42722 Summary:|Incorrect sort through Report Wizard Component:|Database access Version:|680m77 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|none Assigned to:|msc Reported by:|justinclift
------- Additional comments from [EMAIL PROTECTED] Mon Feb 14 04:30:53 -0800 2005 ------- Hi, After creating a very basic report with the Report Wizard, it's generating incorrect results in the output. The (very simple) table has three columns: PRD_ID numeric (primary key) PRD_NAME varchar (default length) PRD_PRICE numeric After going through the report wizard and telling the sort to be on the PRD_ID column (no others) it generates the runs the report. In the output there is 2 pages of data, with one row per page. The first column is ID, and on both pages it's '9876.5' when it should only be simple integers like 1, 2, 3, etc. The next column is NAME and it's '0' on both pages (though it should have text data), and the third column is also '9876.5' on both pages, though it should have integer values like 10, 20, 30, etc. Hope this helps. Regards and best wishes, Justin Clift --------------------------------------------------------------------- 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]