Masters! I beg your help!

I'm currently developing some customizations for a subreport in Production Order report (Material List, Report code: tisfc040804000). My goal is to have the report retrieves serial numbers from table timfc010 (Table name: As-Built Header for Serial End Items).

The problem I have is the report seems not able to retrieve data from timfc010 as it always returned with an empty result, even with hardcoded where clause. The report script was compiled successfully and I'm 100% sure there is data in that table, in fact, I can retrieve them through SQL script, but not in LN. Any thoughts or ideas?

Your help is greatly Appreciated!!!!!!!!!

Here's my code:
-------------------------------------------------------------------------------------------------------
SELECT timfc010.mser
FROM timfc010
WHERE timfc010.pdno = {:tisfc001.pdno}

SELECTDO
y = y + 1
ehc.serial(1, y) = timfc010.mser
SELECTEMPTY
y = y + 1
ehc.serial(1, y) = "Failed"
ENDSELECT
-------------------------------------------------------------------------------------------------------

Aren't mixing up timfc010 and timfc011?

Aren't mixing up timfc010 and timfc011?

Oops, thanks Jaap, I also tried fetch it from timfc011.

Even though it's compiling successfully are you getting any warnings about layouts not being used?

Even though it's compiling successfully are you getting any warnings about layouts not being used?

Thank you for your reply lotius.

Nope, there was only one warning about comparing two double types may yield unpredictable result.