05-24-2008 8:59 PM
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
07-14-2008 7:49 PM
10-30-2008 5:25 PM
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
03-14-2013 9:56 AM