Skip to Content
0
May 24, 2008 at 07:59 PM

SORT Not merging similar fields if there are any editable fields in the ALV

29 Views

Hi All,

I have two issues with my OOPS ALV report.

1) Standard sort is not working :

Output of the report looks like this

WBS TEXT Period 1 Period 2

A Total hours 1 1

A Total hours 1 1

A Total COSt 1 1

A Total COST 1 1

My agenda is to calculate sub total of period1 and period 2 based on fields WBS and TEXT, my output should look like

WBS TEXT Period 1 Period 2

A Total hours 1 1

1 1

Total hours 2 2 ( Sub total )

A Total COST 1 1

1 1

Total COST 2 2 ( Sub total )

To achieve this i pass these two fields in the sort table and pass field subtot = 'X' for TEXT field.

It is working fine, i am getting the sub totals but the WBS field are not grouped( Even though it is a standard functionality).

my output looks like

WBS TEXT Period 1 Period 2

A Total hours 1 1

A Total hours 1 1

Total hours 2 2 ( Sub total )

A Total COST 1 1

A Total COST 1 1

Total COST 2 2 ( Sub total )

I have few editable fields in my output, i came to know this issue is because of the editable fields. have anybody come across the same error.

Please let me know how to achieve the standard sort ( Merging similar values ) functionality even if the output has editable fields.

2) IS it possible to get two Grand total based on a field value . In my example , my TEXT field will always have value either 'Total hours' or 'Total COST'

my output should look like this.

WBS TEXT Period 1 Period 2

A Total hours 1 1

1 1

Total hours(A) 2 2 ( Sub total )

A Total COST 1 1

1 1

Total COST(A) 2 2 ( Sub total )

B Total hours 1 1

1 1

Total hours(B) 2 2 ( Sub total )

B Total COST 1 1

1 1

Total COST(B) 2 2 ( Sub total )

GRAND TOTAL HOURS 4 4

GRAND TOTAL COST 4 4.

Response will be appreciated.

Thanks & Regards,

Rajanidhi Rajasekeran

Edited by: Julius Bussche on Jul 14, 2008 7:39 PM