11-01-2007 7:03 AM
Hi
Now i have a report with select-option and parameter both. My requirement is i want to change the parameter input as a select-option input(RANGE). If i modified its need any changes in select statments or not. only if i make changes in declaration area its enough or its need select statment modification also ? i have little bit confusion kindly help this.
my statement is
PARAMETERS: P_STRUCT(4) TYPE C .
SELECT-OPTIONS: S_MATNR FOR MARC-MATNR.
i want to change the parameter into select-option. Its need any select statment modification?
Thanks,
Mohana
11-01-2007 7:06 AM
Hi,
Yes, you have to change your query according to that.
just change " where s_struct IN s_struct".
Regards,
Prashant
11-01-2007 7:06 AM
Hi,
Yes, you have to change your query according to that.
just change " where s_struct IN s_struct".
Regards,
Prashant
11-01-2007 7:07 AM
hi,
you can change directly from parameters to select-options.
in select statement you need to change replace 'LIKE' with 'IN'.
No more changes are to be done anywhere else.
11-01-2007 7:08 AM
Hi,
If you modify this you have to take care of select Queries and condition statements.
Instead you can do one thing, Click <b>Search Icon</b>, next to print icon.
and give P_STRUCT and click enter.
Now where ever this variable comes there will be = symbol in comparision.
Now change it to <b>IN</b>.
This will be sufficient
11-01-2007 7:09 AM
yes ,
in select query you must have written
where structure = p_struct
now you need to change it to
where structure IN s_structure.
reward and close the thread if answered.
regards
taher
11-01-2007 7:25 AM
Hi Mohana,
Change P_STRUCT to S_STRUCT in select-options.
In Select statement use ( IN S_STRUCT ) instead of ( = P_STRUCT).
Reward pts if usefull.
Srimanta
11-01-2007 7:35 AM
Hi
Can any one plz tell if the parameter variable not a table field. But i need a range for that, so how to convert that parameter field into select-option or range input ?
plz guid me
Mohana