Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007501
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2009-02-11 14:182009-03-10 14:04
ReporternetworkbView Statuspublic 
Assigned Togmauleon 
PriorityimmediateResolutionfixedFixed in Version2.35MP13
StatusclosedFix in branch2.3xFixed in SCM revision13077
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007501: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to backport 0007255 closedrafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
blocks defect 00072182.40 closedgmauleon Dimensional Reports doesn't group propertly  

-  Notes
(0013392)
svnbot (reporter)
2009-02-12 10:19

Repository: openbravo
Revision: 13077
Author: gmauleon
Date: 2009-02-12 10:18:59 +0100 (Thu, 12 Feb 2009)

fixes bug 0007501: Dimensional Reports doesn't group propertly

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

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

- Issue History
Date Modified Username Field Change
2009-02-11 14:18 rafaroda New Issue
2009-02-11 14:18 rafaroda Assigned To => gmauleon
2009-02-11 14:18 rafaroda Regression testing => No
2009-02-11 14:18 rafaroda Issue generated from 0007219
2009-02-11 14:19 rafaroda Reporter rafaroda => networkb
2009-02-11 14:19 rafaroda Priority high => immediate
2009-02-11 14:19 rafaroda Status new => scheduled
2009-02-11 14:19 rafaroda fix_in_branch => 2.3x
2009-02-11 14:19 rafaroda Relationship added blocks 0007218
2009-02-11 14:19 rafaroda Relationship added related to 0007255
2009-02-12 10:19 svnbot Checkin
2009-02-12 10:19 svnbot Note Added: 0013392
2009-02-12 10:19 svnbot Status scheduled => resolved
2009-02-12 10:19 svnbot Resolution open => fixed
2009-02-12 10:19 svnbot svn_revision => 13077
2009-03-06 16:09 psarobe Fixed in Version => 2.35MP12
2009-03-10 14:04 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker