topic Re: abt selection screen parameters in Application Development and Automation Discussions

abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:27:56 GMT

hi all

i have made a report with selection screen which has two parameters

but to run that report i have to fill that two fileds

is there any way that i can run my report without filling the two fields of my selection screen. Both the fields are used in the where condition in my inner join query.

thanx n regards

Re: abt selection screen parameters

kiran_k8 — Fri, 17 Aug 2007 05:31:56 GMT

Hi,

Once you specify those fields in the where clause then it is a must that you need to give some value at selection screen level.It is a must.

K.Kiran.

Re: abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:32:00 GMT

If u want to run the report without filling the two field ...use select-options rather than parameters.

SELECT-OPTIONS s_carrid FOR spfli_wa-carrid NO-DISPLAY NO-EXTENSION .

Re: abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:32:41 GMT

Hi,

U have two parameters, but dont want to fill them..May i know under what scenario u need this sort of..

Re: abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:33:10 GMT

If the selection screen parameters are obligatory, u've to fill them otherwise

change the parameter as a select-option with the additions NO-EXTENSION and NO-INTERVAL. which makes the select-option look like a parameter and in the WHERE clause use the <b>IN</b> operator instead of <b>EQ</b>

Re: abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:34:42 GMT

it is not mendatory to fill these two fields unless n until u'r not making them OBLIGATROY. n offcorse u'r query will run execute perfectly but just check the query whether there'r a huge recordset selected while u'r keeping these fileds blank. otherwise u should take them as OBLIGATORY parameters.

reward if useful

S@meer

Re: abt selection screen parameters

Former Member — Fri, 17 Aug 2007 05:41:07 GMT

thanx all

i think select-options wid no no interval and no extention wil help

thanx all for replying