2007 Sep 21 5:08 AM
Dear sir,
this is my calculation..
<MON/YR1> <Project id1> F&G
<MON/YR1> <Project id2> F&G
<MON/YR1> <Project id3> F&G
<MON/YR1> <Project id4> F&G
<MON/YR1> <Project id5> F&G
First i take Project id only F&G Value
Taking Project id Same month and year.
Month year i gave on select options screen.
so any month and year i will give on that place taking particular month and year and then corresponding project id will taken..
Dear sir,
this is my calculation..
<MON/YR1> <Project id1> F&G
<MON/YR1> <Project id2> F&G
<MON/YR1> <Project id3> F&G
<MON/YR1> <Project id4> F&G
<MON/YR1> <Project id5> F&G
First i take Project id only F&G Value
Taking Project id Same month and year.
Month year i gave on select options screen.
so any month and year i will give on that place taking particular month and year and then corresponding project id will taken..
2007 Sep 21 5:14 AM
Hi Sankar,
can you Please clarify the problem by tellin the scenario and expected output.
2007 Sep 21 5:34 AM
Deae sir,
This is my selection screen.....
here i m give some amount band values
eg. 1 to 10
11 to 20
21 to 30
31 to 40
41 to 50
Amount band 1: To
Amount band 2: To
Amount band 3: To
Amount band 4: To
Amount band 5: To
Customer Group: To
Customer : To
Project ID : To
Occasion ID : To
Mon/Yr 1:
Mon/Yr 2:
Output Format...
1 Amount band (as defined on the parameters before report exec) *any of the two years falling within the range
2 Customer Sold to Party No.
3 Name Sold to Party Name
4 Address Sold to Address
5 Postal Code Sold to Postal Code
6 Contact Person Contact Person Name
7 Email Contact Person Email
8 Tel # Contact Person Tel 1 & 2
9 SSID SSID
10 <Mon/Yr 1> <Proj ID 1> Gross Amt F&G
.
<Mon/Yr 1> <Proj ID 5> Gross Amt F&G
<Mon/Yr 2> <Proj ID 1> Gross Amt Hamper
.
<Mon/Yr 1> <Proj ID 5> Gross Amt Hamper
11 Y1 Total
12 Y2 Total
above table show my output format....
this are all design in alv report....
now i m finished all the design... i dont know the calculation part pls
tell me sir,
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |