0007501: Dimensional Reports doesn't group propertly

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007501

Openbravo ERP

07. Sales management

public

2009-02-11 14:18

2009-03-10 14:04

Reporter

networkb

Assigned To

gmauleon

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

2.35MP13

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007501: Dimensional Reports doesn't group propertly

Description

When 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 Reproduce

1.-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

Tags

No tags attached.

Relationships

related to	backport	0007255		closed	rafaroda	Sales Invoice Dimensional Report doesn't group by business partner when sorting.
blocks	defect	0007218	2.40	closed	gmauleon	Dimensional Reports doesn't group propertly