Hello,
I am working on updating an Asset Balance report query(which runs on a multiprovider) so that the the result is a value comparison between different Dep.Areas
Assume the data:
Ccd--
10 -
100--
1000
10 -
100--
2000
10 -
100--
8000
(All the KF values are not direct values from the multiprovider)
User enters values for (mandatory variables) at the time of executing the report for: FiscalYear/Period, Ccd, Asset, Depr Area
--> Whatever the value is entered by the user for DeprArea, ( KF(80)-key figure value of Depr Area(80) should be populated as shown below)
**********************************************************************************
If user enters: Ccd - 10, Asset - 100, Depr.Area - 10
The requirement is to get the output as:
Ccd--
KF(80)
10 -
100--
*******************************************************************************
If user enters: Ccd - 10, Asset - 100, Depr.Area - 20
The requirement is to get the output as:
Ccd--
KF(80)
10 -
100--
*******************************************************************************
-
As per my workaround on this, I am getting the report results as below in two different rows:
If I give the values: Ccd - 10, Asset - 100, Depr.Area - 20
Output I am getting is:
Ccd--
KF(80)
10 -
100--
10 -
100--
I want the output when I run my query as below in a single row:
Ccd--
KF(80)
10 -
100--
-
To get the output, I am assuming only User Exit / Virtual Char can give the result as expected.
Please advice if there is a way to get the output as I need and please advise the logic that best suits for this.
I am assuming, when I run my query since 2 records are returned, what if I capture the 2 records and process the records in the user exit ( change value of Life(3) to Life(2) using Virtual char )?
Does this logic worksout?
if so what will be the results in my query after processing of the user exit? Output_A(1 row) OR Output_B(2 rows)?
_Output:A:-- 10--
100
2
2000
--8000
_Output:B:--
10--
100
2
2000
--8000
10--
100
2
2000
--8000
Please advice the best workaround or solution to achieve this!!!
Does this user exit effects any other reports?
Thanks
AK
Edited by: AK I on Feb 20, 2009 5:49 AM