Skip to Content
avatar image
Former Member

abt selection screen parameters

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 05:32 AM

    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 .

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2007 at 05:31 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 05:32 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 05:33 AM

    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>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 05:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanx all

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

      thanx all for replying