topic Re: GET statement in report in Application Development and Automation Discussions

GET statement in report

dhiraj_bhatia1 — Fri, 25 Feb 2011 07:23:49 GMT

Hii all..

I have a report in which i have attached a LDB...in this report I want that GET statement should get execute depending on One check condition otherwise i am fetching data in report itself...

CHECK NOT p_abc IS INITIAL

AND NOT p_xyz IS INITIAL.

GET zxyz_hdr.

but even if this condition is false GET statement is getting executed and data is coming from LDB...

Is there any way that i can stop execution of GET statement depending on some condition???

Regards Dhiraj B,

Re: GET statement in report

Former Member — Fri, 25 Feb 2011 07:45:12 GMT

Hi,

try it with an if condition instead of check.

if p_abc <> initial and p_xyz <> initial.

get....

endif.

regards Nicole

Re: GET statement in report

Former Member — Fri, 25 Feb 2011 07:47:33 GMT

Since, it is an event you cannot control the call of the event based on the condition. But what you can do alternatively is control the flow after the event is triggered.

May be you can reverse your condition. Something like this,


GET zxyz_hdr.

if p_abc is initial and p_xyz is initial.
reject.
endif.

Or you can also use STOP statement so that control will go to End of Selection if your condition is not met. Something like this,


if p_abc is initial and p_xyz is initial.
STOP.
endif.

GET zxyz_hdr.

Regards

Ranganath

Re: GET statement in report

dhiraj_bhatia1 — Fri, 25 Feb 2011 08:47:32 GMT

Dear Nicole,

IF condition will gives an ERROR...because GET can not be written between IF..ENDIF.

Re: GET statement in report

Former Member — Fri, 25 Feb 2011 09:18:09 GMT

Hi ,

Yes..u can write "Return" in the if , endif statement and that will retrun from the current block. And certainly, it will not execute GET statement.

Rakesh