topic Re: Submit statement in Application Development and Automation Discussions

Submit statement

Former Member — Fri, 08 Dec 2006 10:03:04 GMT

Hi all,

I have a requirement to call a report through a module pool program with some of the fields in the reoprt selection screen populated. I am using the submit statement -

SUBMIT REPORT VIA SELECTION SCREEN WITH values.

But the report selection screen has certain default fields populated. I have to clear these fields too. How do I do it ?

If i pass WITH ' ' in the submit statement, the value is set as = BLANK. I do not want this.

Cheers,

Usha

Re: Submit statement

Former Member — Fri, 08 Dec 2006 10:20:17 GMT

Hi usha,

1. I just tried, its working fine.

2. When we pass with Fieldname = '',

it works perfectly fine.

regards,

amit m.

Re: Submit statement

Former Member — Fri, 08 Dec 2006 10:23:39 GMT

hi,

try this code.

SUBMIT zreport with p_param1 = 'value'

with p_param2 = 'value'.

i think this will help u

Re: Submit statement

Former Member — Fri, 08 Dec 2006 10:31:27 GMT

Hello Amit,

Thank you. But this condition adds a condition in the selection screen as = BLANK. This will not fetch all the records. it works fine if it is a parameter, but not for select option.

- Usha