Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member764673
Participant
0 Kudos

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

3 REPLIES 3

former_member764673
Participant
0 Kudos

Solved Myself.

Former Member
0 Kudos

Hi

If I make the editable field to non editable then sort & cell merge is happening but if I make any of the field as editable then merge is not working shall i request you the solution

Regards-Sreeni

former_member193724
Active Participant
0 Kudos

can u please provide the solution.....