Hi all experts,
I'm facing a problem to track back record to get the Title which its ProgrammeID is not null. My scenario is like below:
presentationID ProgrammeID Title
12 123 Singing Competition
13 NULL Promotion Break 1 minute
15 146 Morning News
17 105 Cooking Programme
19 NULL Promotion Break 1 minute
24 NULL Promotion Break 1 minute
30 NULL Promotion Break 1 minute
67 NULL Promotion Break 1 minute
Condition:
If the programmeID is not null it should show Title and if the programmeID is null then the system will be continued automatically to track back the previous row data until the system found out the ProgrammeID is not null. Consequently the Title will be shown in the report.
Eg: My report is referring to presentationID=67, so in my report the Title should be Cooking Programme.
My Question is how i get the correct Title ? Using while loop and previous() function will be helped?
I need to get the answer as soon as possible.
Thanks in advance.
Regards,
Wei LOO
Edited by: Wei Loo Tong on May 5, 2010 4:55 AM