Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 173355

Summary: Confusing error when incorrect aggregate level used in computed column
Product: z_Archived Reporter: Gary Xue <xxue>
Component: BIRTAssignee: Lin Zhu <lzhu>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3    
Version: 2.2.0   
Target Milestone: 2.2.0 RC2   
Hardware: PC   
OS: All   
Whiteboard:
Attachments:
Description Flags
report design none

Description Gary Xue CLA 2007-02-07 16:41:09 EST 
Run the attached report design, which contains a data set computed column with expression: Total.count(Total.NO_FILTER, 1), produces the following error:

  The data type of computed column "CountColumn" is java.lang.Integer, 
  but one of  its value is "null", which cannot be converted to java.lang.Integer.

This error is very confusing and does not reflect the actual source of the error.

Data set computed column cannot use aggregation over any grouping level other than OVERALL, since data sets do not contain groups. So the expected error message in this should read something like this: 

Incorrect aggregation group level in expression for data set computed column "CountColumn". Only Total.OVERALL is permitted.
Comment 1 Gary Xue CLA 2007-02-07 16:41:56 EST 
Created attachment 58491 [details]
report design
Comment 2 Lin Zhu CLA 2007-03-29 05:20:47 EDT 
This bug iwill be automatically obsoleted after we adapting new Aggregation framework. Defer it to RC0.
Comment 3 Lin Zhu CLA 2007-05-11 04:27:43 EDT 
We've finished Data project changes. The changes in UI data set editor would depends on 130686 the aggregation builder.
Comment 4 Lin Zhu CLA 2007-05-28 06:27:15 EDT 
The new computed column aggregation builder is added. The bug is obsoleted.