Hi I am new to cognos
i have columns as
change no,Implementaionstarttime, Implementaionendtime, submit for approavaldate, approval/denial date,approval group in report studio(query1)
Chnageno Implementaionstarttime Implementaionendtime submit for approval date approval/denial date approval Grosp
CR127 Sep 9, 2017 8:00:00 AM Sep 10, 2017 10:00:00 PM Aug 29, 2017 11:48:40 PM Aug 31, 2017 10:20:16 AM CMD-Birmingham
CR127 Sep 9, 2017 8:00:00 AM Sep 10, 2017 10:00:00 PM Aug 29, 2017 11:48:40 PM Sep 6, 2017 3:50:21 PM IBMNA-HBCA-DESR
CR127 Sep 9, 2017 8:00:00 AM Sep 10, 2017 10:00:00 PM Aug 29, 2017 11:48:40 PM Sep 8, 2017 5:57:20 AM HBCN-IUDGR
CR127 Sep 9, 2017 8:00:00 AM Sep 10, 2017 10:00:00 PM Aug 29, 2017 11:48:40 PM Aug 30, 2017 3:22:56 AM ISTH-GRC
CR127 Sep 9, 2017 8:00:00 AM Sep 10, 2017 10:00:00 PM Aug 29, 2017 11:48:40 PM Sep 5, 2017 8:55:03 AM IBM-TYIY
Now the user requirement is he wants the last Approval group of approval/denial date. supose for the above change no the output must come as Sep 8, 2017 5:57:20 AM(HBCN-IUDGR).like this i have 10000 change no's. i have to get the last approval group basedon approval/denial date
How can i do in report studio , can anyonehelp please
hi can anyone pleas reply for me si am very new to cognos
Quote from: msailaja484 on 28 Sep 2017 08:13:49 AM
hi can anyone pleas reply for me si am very new to cognos
Less than an hour has elapsed since your original post. If you need help very quickly you should go through your company's support and training organizations rather than a forum like this. Take a look at the forum etiquette to understand how to get the best out of this wonderful forum.
maximum([Approval / Denial Date] for [Change No])