topic Re: Problem with select options in Application Development and Automation Discussions

Problem with select options

Former Member — Tue, 22 Apr 2008 12:32:05 GMT

Hi Friends.

I am facing a problem in my report , in the selection screen i have WBS Element , Year, Month as input . My problem is , if i use parameter for WBS element and if i enter a particular WBS it is fetching data and displaying it . And if i use select option instead of parameter and if i give the same WBS it is not fetching the data. My client is asking to use select option only as he wants to give WBS range in the selection screen.

Please check this .

Re: Problem with select options

Former Member — Tue, 22 Apr 2008 12:34:53 GMT

you will have to paste the code here

are u using where wbs = select option

or wbs in selectoption

in your select query?

try using IN

Re: Problem with select options

Former Member — Tue, 22 Apr 2008 12:35:20 GMT

Hi Rohini,

Can you show the select statement

I hope you are using IN for Slect options

SELECT ....

...

WHERE <WBS> IN S_WBS..

Re: Problem with select options

Former Member — Tue, 22 Apr 2008 12:38:25 GMT

Hi,

I think you may have this problem

Please check once in Select Query what you are writing, I mean.

for parameters in where condition EQ you can use, but SELECT-OPTIONS you have to use IN option.

anyway can u send your code I can give better solution.

Thanks

Ganesh