08-17-2007 6:27 AM
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
08-17-2007 6: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 .
08-17-2007 6: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.
08-17-2007 6: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 .
08-17-2007 6:32 AM
Hi,
U have two parameters, but dont want to fill them..May i know under what scenario u need this sort of..
08-17-2007 6: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>
08-17-2007 6: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
08-17-2007 6:41 AM
thanx all
i think select-options wid no no interval and no extention wil help
thanx all for replying