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]

Reply via email to