parameter populated but obtainselect cant see it....

[t16turbo]

Hi all,

i'm having real problems with my code.
I have entered a parameter named NewReportApp:aram_program .

in my obtainselect statement I have some script:

If NewReportApp:aram_program <>0 Then
whereStr = "WHERE prog.id (+) = tsk.prprojectid AND tsk.prexternalid (+) = prj.unique_name AND prog.is_program = 1 and prog.ID in (SELECT ID FROM ODF_CA_PROJECT WHERE DSTI_PROJ_REF = '" & NewReportApp:aram_program & "')) prog "

Else
whereStr = "WHERE prog.id (+) = tsk.prprojectid AND tsk.prexternalid (+) = prj.unique_name AND prog.is_program = 1 and prog.ID in (SELECT ID FROM ODF_CA_PROJECT)) prog "

End If


when I have entered a value, it skips into the 'Else' section.
I cannot work ou why.
I've included a field in the before section of my report, to show the parameter value and there is definitely a value in there..
can anyone suggest why this might be happening?

 

[milton747]

Have you tried entering:

ShowFactoryStaus(NewReportApp:aram_program)

to see the value being tested?