I have a situation like one manager can have multiple
learners under him. each learner will registered for more
than one certifications . their statuses for different
courses like completed, inprogress, dropped, no
certifications.
the question is i have check for each user for statuses if
he had some completed certifications i have to get latest
completed date and omit all other stauses. if he had no
complete staus then i have to get latest inprogress record
based on date. like this i have to select only one record
for user.
but i am getting one row for each status. among all
completion status one record, for all inprogress one
record, for all dropped status one record. how can i show
only one record
- 0 Answers
- 2017 Views
- Flextronics, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
why we are using derived tables ?how it will help?
What is the user Object ? What is the need of it?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
how to create a derived table in designer? i need steps regarding derived table
Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90
How to get the data from the two different sourcess
How to create predefined filters in B.O.
what will be the contents for a functional requirements specifications
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
limitaions of cross tab ?
Teradata 
