Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007218Openbravo ERP07. Sales managementpublic2009-01-29 11:472009-04-23 17:32
Reportergmauleon 
Assigned Togmauleon 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007218: Dimensional Reports doesn't group propertly
DescriptionWhen you execute dimensional Reports choosing "Sort By Ascending/Descending Amount" results appear sorted but they don't appear grouped.
(It works properly when executing with "sort standard")

These Dimensional reports are failing
-Sales Dimensional Report
-Shipments Dimensional Report
-Sales Order Returns Dimensional Report
-Purchase Dimensional Report
-Material Receipts Dimensional Report
-Purchase Invoice Dimensional Report
Steps To Reproduce1.-Select one of the dimensional reports commented
2. Set From Date and To Date
3. Dimensions: choose Business Partner
4. Sort: choose Ascending or Descending
5. View Results
Proposed Solution-Avoid the usage of UOMSYMBOL in the SQl querys. Some result are duplicated because the usage of this column to order the result.
Additional Information
Tagscomsup_sprint5, main
Relationships
related to defect 00071412.40 closed rafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
depends on backport 00072192.40 closed gmauleon Dimensional Reports doesn't group propertly  
depends on backport 0007501 closed gmauleon Dimensional Reports doesn't group propertly 
Attached Filespng error.png (71,796) 2009-01-29 11:47
https://issues.openbravo.com/file_download.php?file_id=761&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-01-29 11:47gmauleonNew Issue
2009-01-29 11:47gmauleonAssigned To => gmauleon
2009-01-29 11:47gmauleonsf_bug_id0 => 2545198
2009-01-29 11:47gmauleonFile Added: error.png
2009-01-29 11:47gmauleonRegression testing => No
2009-01-29 11:47gmauleonStatusnew => acknowledged
2009-01-29 11:47gmauleonStatusacknowledged => scheduled
2009-01-29 11:47gmauleonfix_in_branch => trunk
2009-01-29 11:49rafarodaStatusscheduled => feedback
2009-01-29 11:49rafarodaStatusfeedback => new
2009-01-29 12:00gmauleonfix_in_branchtrunk =>
2009-01-29 12:00gmauleonSummarysome Dimensional Reports doesn't group by business partner when sorting. => Dimensional Reports doesn't group propertly
2009-01-29 12:00gmauleonDescription Updated
2009-01-29 12:00gmauleonSteps to Reproduce Updated
2009-01-29 12:04rafarodaStatusnew => scheduled
2009-01-29 12:04rafarodafix_in_branch => trunk
2009-01-29 15:13gmauleonRelationship addedrelated to 0007141
2009-01-30 12:39svnbotCheckin
2009-01-30 12:39svnbotNote Added: 0012894
2009-01-30 12:39svnbotStatusscheduled => resolved
2009-01-30 12:39svnbotResolutionopen => fixed
2009-01-30 12:39svnbotsvn_revision => 12554
2009-01-30 12:39gmauleonTag Attached: comsup_sprint5
2009-02-11 14:13rafarodaRelationship addeddepends on 0007500
2009-02-11 14:14rafarodaRelationship deleteddepends on 0007500
2009-02-11 14:19rafarodaRelationship addeddepends on 0007501
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 17:32psarobeStatusresolved => closed

Notes
(0012894)
svnbot   
2009-01-30 12:39   
Repository: openbravo
Revision: 12554
Author: gmauleon
Date: 2009-01-30 12:39:36 +0100 (Fri, 30 Jan 2009)

Fixes 0007218: Dimensional Reports doesn't group properly

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12554&sc=1 [^]