I am trying to add one column to this report tfacp431911000 from table tdpur406 the field ddte or rcno. It doesn’t to get any values. I tried putting it in different layout of the report, try field variable or hard coded variable in the SQL statement it doest seem to show the value I need even when in debug. Like it cannot find any record. If run my SQL Statement in SSMS it works. I am running out of ideas to try…
Am I missing something or I just need to see the scenario on different set of eyes…
Please see attach doc to futher illustrate the problem.

I am just trying display any of the fields in this SQL to be added as a column in the report.

select
tdpur406.ddte, tdpur406.rcno
from
tdpur406
where
tdpur406.orno = "NWC000016" AND
tdpur406.pono = 10 AND
tdpur406.sqnb = 1 AND
tdpur406.rsqn = 1
as set with 1 rows
selectdo
endselect



5401

In debug mode does they query return values for ddte or rcno? I would confirm the query works first. Then I would run through debug mode to make sure the value was set before it hit which ever layout it is in. Normally I just put queries to retrieve additional data in the detail before layout.

Hello,

check if there is a print condition at "after.rep.pono.2" ?


Use code tags, please !


select tdpur406.ddte, tdpur406.rcno
from tdpur406
where tdpur406.orno = "NWC000016"
and tdpur406.pono = 10
and tdpur406.sqnb = 1
and tdpur406.rsqn = 1
as set with 1 rows
selectdo
endselect


Regards

There is print codition at "after.rep.pono.2" in debug it passes by that line.
In debug mode it goes through the query and it doesn't show any values it is 0 for the ddte and blank space for rcno. I hard coded the values already because I know that SO has a value and run the same query in SSMS and it returns a value.

that is why it so perplexing... I run out of idea on what to check...

select
tdpur406.ddte, tdpur406.rcno,tdpur406.orno,tdpur406.pono,tdpur406.sqnb,tdpur406.rsqn
from
tdpur406
where
tdpur406.orno = "NWC000016" AND
tdpur406.pono = 10 AND
tdpur406.sqnb = 1 AND
tdpur406.rsqn = 1
as set with 1 rows
selectdo
endselect

OR

select tdpur406.*
from
tdpur406
where
tdpur406.orno = "NWC000016" AND
tdpur406.pono = 10 AND
tdpur406.sqnb = 1 AND
tdpur406.rsqn = 1
as set with 1 rows
selectdo
endselect


May be this is not required, but give it a try. May be this works as sometimes the select doesn't captures exact values.

Can you post the whole script? You did declare that table in the script? And you are positive about that data in the query? I mean - are there trailing spaces on that order number? Until the query actually returns data I don't think it matters where you put it, have to fix that first.

please check if the fields exist in your report input fields (ttadv3532m000).