Issue 118074 - 'Sorting and Grouping' in Report affects summation of fields
Summary: 'Sorting and Grouping' in Report affects summation of fields
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: OOo 3.3
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-24 12:34 UTC by stiebler_2
Modified: 2013-02-07 22:35 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
ZIP file containing Test_Sort_Database.odb and a readme.txt (10.70 KB, application/zip)
2011-05-24 12:34 UTC, stiebler_2 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description stiebler_2 2011-05-24 12:34:11 UTC 
Created attachment 76548 [details]
ZIP file containing Test_Sort_Database.odb and a readme.txt

The Wiki-recommended User-defined function used to sum values in fields (see attachment for example*) works perfectly with the Sun Report Builder, if the 'Sorting and Grouping' Report function is not engaged.
If 'Sorting and Grouping' is permitted for ANY field, the results from the User-defined function for ANY (other or same) field are nonsense.

Problem is easy and reliable to reproduce. A very simple database example with a 'readme' is attached.

*The Function:
if function name is 'CostCalc', the formula is [CostCalc]+[fieldname], initial value is [fieldname], where 'fieldname' is the name of the field to be summed.
Comment 1 r4zoli 2011-05-24 16:55:55 UTC 
I can confirm it in OOo 3.4 Beta1 with 1.2.2 betam105, and OOo 3.3. ORB 1.2.1-rev2.

Problems with user defined accumulation functions and grouping.
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:19:18 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.