Skip to Content
Former Member
May 04, 2010 at 02:25 AM

How to Track back the record under condition??


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


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.



Edited by: Wei Loo Tong on May 5, 2010 4:55 AM