Issue 118074

Summary: 'Sorting and Grouping' in Report affects summation of fields
Product: Base Reporter: stiebler_2 <johnpye-white1>
Component: ReportBuilderAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, r4zoli
Version: OOo 3.3   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
ZIP file containing Test_Sort_Database.odb and a readme.txt none

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.