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
No Answer is Posted For this Question
Be the First to Post Answer
What is maximum number of promts we can give in a BO report?
Report have 10000 records,how to restrict the end user to 1000 Records?
Did you face any problems while creating reports? Name? Solutions?
WHO ARE THE USERS OF THE REPOSITORY?
Explain in detail about type 2(scd),
What is mean by tuning the report?
What is the difference between the Bo 3.0 and 3.1?
2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?
what is the difference between bo and cognos?
what is local filter
Explain about derived tables?
What is BOMain.Key?