How to Track back the record under condition??

78 Views

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