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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007218
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2009-01-29 11:472009-04-23 17:32
ReportergmauleonView Statuspublic 
Assigned Togmauleon 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision12554
ProjectionnoneETAnoneTarget Version2.40
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

0007218: 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.
Tagscomsup_sprint5, main
Attached Filespng file icon error.png [^] (71,796 bytes) 2009-01-29 11:47

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00071412.40 closedrafaroda Sales Invoice Dimensional Report doesn't group by business partner when sorting. 
depends on backport 00072192.40 closedgmauleon Dimensional Reports doesn't group propertly  
depends on backport 0007501 closedgmauleon Dimensional Reports doesn't group propertly 

-  Notes
(0012894)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2009-01-29 11:47 gmauleon New Issue
2009-01-29 11:47 gmauleon Assigned To => gmauleon
2009-01-29 11:47 gmauleon sf_bug_id 0 => 2545198
2009-01-29 11:47 gmauleon File Added: error.png
2009-01-29 11:47 gmauleon Regression testing => No
2009-01-29 11:47 gmauleon Status new => acknowledged
2009-01-29 11:47 gmauleon Status acknowledged => scheduled
2009-01-29 11:47 gmauleon fix_in_branch => trunk
2009-01-29 11:49 rafaroda Status scheduled => feedback
2009-01-29 11:49 rafaroda Status feedback => new
2009-01-29 12:00 gmauleon fix_in_branch trunk =>
2009-01-29 12:00 gmauleon Summary some Dimensional Reports doesn't group by business partner when sorting. => Dimensional Reports doesn't group propertly
2009-01-29 12:00 gmauleon Description Updated
2009-01-29 12:00 gmauleon Steps to Reproduce Updated
2009-01-29 12:04 rafaroda Status new => scheduled
2009-01-29 12:04 rafaroda fix_in_branch => trunk
2009-01-29 15:13 gmauleon Relationship added related to 0007141
2009-01-30 12:39 svnbot Checkin
2009-01-30 12:39 svnbot Note Added: 0012894
2009-01-30 12:39 svnbot Status scheduled => resolved
2009-01-30 12:39 svnbot Resolution open => fixed
2009-01-30 12:39 svnbot svn_revision => 12554
2009-01-30 12:39 gmauleon Tag Attached: comsup_sprint5
2009-02-11 14:13 rafaroda Relationship added depends on 0007500
2009-02-11 14:14 rafaroda Relationship deleted depends on 0007500
2009-02-11 14:19 rafaroda Relationship added depends on 0007501
2009-04-22 11:24 psarobe Tag Attached: main
2009-04-23 17:32 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker