Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007219Openbravo ERP07. Sales managementpublic2009-01-29 11:472009-03-04 13:38
Reportergmauleon 
Assigned Togmauleon 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target Version2.40Fixed in Version2.40MP3 
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
Summary0007219: 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
Relationships
related to backport 00071922.40 closed rafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
blocks defect 00072182.40 closed gmauleon Dimensional Reports doesn't group propertly  
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-29 12:04rafarodaTypedefect => backport
2009-01-29 12:04rafarodafix_in_branch => 2.40
2009-01-29 15:12gmauleonTag Attached: comsup_sprint5
2009-01-29 15:12gmauleonTag Attached: Messages
2009-01-29 15:12gmauleonTag Detached: Messages
2009-01-29 15:13gmauleonRelationship addedrelated to 0007192
2009-01-29 15:15svnbotCheckin
2009-01-29 15:15svnbotNote Added: 0012822
2009-01-29 15:15svnbotStatusscheduled => resolved
2009-01-29 15:15svnbotResolutionopen => fixed
2009-01-29 15:15svnbotsvn_revision => 12480
2009-01-29 16:57svnbotCheckin
2009-01-29 16:57svnbotNote Added: 0012836
2009-01-29 16:57svnbotsvn_revision12480 => 12494
2009-02-11 14:18rafarodaIssue cloned0007501
2009-03-03 17:31psarobeFixed in Version => 2.40MP3
2009-03-04 13:38sureshbabuStatusresolved => closed
2009-03-04 13:38sureshbabuNote Added: 0014386

Notes
(0012822)
svnbot   
2009-01-29 15:15   
Repository: openbravo
Revision: 12480
Author: gmauleon
Date: 2009-01-29 15:15:11 +0100 (Thu, 29 Jan 2009)

Fixes 0007219 Removed un-needed UOMSYMBOL from SELECT and GROUP BY since the cut by UOM is already done when showing product dimension.

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12480&sc=1 [^]
(0012836)
svnbot   
2009-01-29 16:57   
Repository: openbravo
Revision: 12494
Author: gmauleon
Date: 2009-01-29 16:57:12 +0100 (Thu, 29 Jan 2009)

related to issue 7219 Dimensional Reports doesn't group propertly

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
U branches/r2.40/src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12494&sc=1 [^]
(0014386)
sureshbabu   
2009-03-04 13:38   
http://79.125.57.19/openbravo240mp3oracle [^]