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.

Thanks HTH, i think your formula should be worked fine if there is no any filtering.

I found out that, after the filtering, all of my data is with null progID.
Is there a way to let me track back the ProgID with the proper title in the database. In the other hand, the formula would not be affected by the filtering, is that possible????

Let us using back the same sample data but all the data with ProgID will be filtered out. Just leave the data with NULL progID.

Any suggestion is glad for me..

Thank you.


Edited by overcharge - 06 May 2010 at 3:37pm