Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from rameshbabuc on Feb 18 at 5:40 AM hi,
Just create a variable on this Date field with range.
thanks
Ramesh Babu
| | | ---------------Original Message---------------
From: Harshit Pandey
Sent: Monday, February 17, 2014 8:56 AM
Subject: Report Based On Selection of Date Field
Dear Experts
I have a scenario in which we are getting data as stated below under INPUT and we want to report it based on Selection of Date field on selection screen and report according to the Date range provided at input as shown in OUTPUT
INPUT :
TRAN_ID Char Date Quantity
1 AA 01.02.2014 1000
2 BB 01.02.2014 2000
3 AA 02.02.2014 1500
4 CC 03.02.2014 1230
5 BB 03.02.2014 1100
6 CC 04.02.2014 1900
7 AA 04.02.2014 2500
8 DD 05.02.2014 1950
9 CC 05.02.2014 1800
10 DD 06.02.2014 1600
SELECTION
DATE 01.02.2014 TO 05.02.2014
OUTPUT:
Char Date Quantity MAX Diff MIN Diff
AA 01.02.2014 1000 1500 0
AA 02.02.2014 1500 1000 500
AA 04.02.2014 2500 0 1500
BB 01.02.2014 2000 0 900
BB 03.02.2014 1100 900 0
CC 03.02.2014 1230 670 0
CC 04.02.2014 1900 0 670
CC 05.02.2014 1800 100 570
DD 05.02.2014 1950 0 0 |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
